Balnk cells
 

Hi
Any help
I have a cell resulting from an IF function, the result is either a
number or blank (“”).
I want to write If function in the next cell for
IF(AND(0AE11<=3);"pass";IF(AE11=0;"notpas";"fine" )), this work when
number is in the cell, I want another condition that if the cell is
blank (“”), the result will be “notpass”, is there anyway to recognize
the (“”).
Thanks in advance
Jam

Balnk cells
 

To make sure
=if(len(trim(ae11))<1,"really blank","someone touched the space bar")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
Hi
Any help
I have a cell resulting from an IF function, the result is either a
number or blank (“”).
I want to write If function in the next cell for
IF(AND(0AE11<=3);"pass";IF(AE11=0;"notpas";"fine" )), this work when
number is in the cell, I want another condition that if the cell is
blank (“”), the result will be “notpass”, is there anyway to recognize
the (“”).
Thanks in advance
Jam

Balnk cells
 

try this

=IF(AND(AE110,AE11<=3),"pass",IF(OR(AE11="",AE11= 0),"notpas","fine"))





On Oct 2, 7:09*pm, wrote:
Hi
Any help
I have a cell resulting from an IF function, the result is either a
number or blank (“”).
I want to write If function in the next cell for
IF(AND(0AE11<=3);"pass";IF(AE11=0;"notpas";"fine" )), this work when
number is in the cell, I want another condition that if the cell is
blank (“”), the result will be “notpass”, is there anyway to recognize
the (“”).
Thanks in advance
Jam