Thread: Balnk cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default 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