Remove the "False" from Statement

[Hardip]

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

 

[JE McGimpsey]

One way:

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

 

[Don Guillett]

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

 

[barrfly]

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

 

[Hardip]

Thanks - I feel stupid now!!!

One way:

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