Thread: Balnk cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jamalhakem@gmail.com is offline
external usenet poster
 
Posts: 37
Default 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