Balnk cells

[jamalhakem]

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(0>AE11<=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

 

[Don Guillett]

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
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(0>AE11<=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

 

[muddan madhu]

try this

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