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

Remove the "False" from Statement
 

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

Remove the "False" from Statement
 

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


--
Don Guillett
SalesAid Software

"Hardip" wrote in message
...
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

Remove the "False" from Statement
 

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


--
barrfly

Excel User - Energy markets
------------------------------------------------------------------------
barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141
View this thread: http://www.excelforum.com/showthread...hreadid=527166

Remove the "False" from Statement
 

Thanks - I feel stupid now!!!



"JE McGimpsey" wrote:

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