Match Clause

[#1]

Hi,

I have the following formula, please advise where I am going wrong:

=If (MATCH (Closed_Date = " "),'Closed Cases','Open Cases')

I need all blanks in the column to be shown a s a Closed Cases in a list box and all dates to be shown as Open Cases.

[sunny_talwar]

May be try this:

=If(Len(Trim(Closed_Date)) = 0, 'Closed Cases', 'Open Cases')

[richard_chilvers]

I don't think your MATCH format is correct.

It should be along the lines of: match( M, 'Jan','Feb','Mar')

See the help for fuller details.

[19iv1987]

Hi Yolanda,

can u better explain what you're try to get?