Balnk cells

J

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
 
D

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
 
M

muddan madhu

try this

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top