View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hardip
 
Posts: n/a
Default Remove the "False" from Statement

Hi All

I have created the following forumula:

=IF(AND($W2=3,$W2<4),"Greater than 2 Year Old")

What I want to do is leave the cell blank - I Don't want a 'space' or the
FALSE written in the cell. How do I remove this?

I'd appreciate any pointers.

TIA - H