One way:

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

In article ,
Hardip wrote:

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