IF statement result

T

TazzyDal

I have an IF statement that is as follows:

=if(a1=99%,"yes,"no")

What I would like to see is if cell a1 is blank, then neither "yes" o
no" are returned, the cell would remain blank.....
 
J

JE McGimpsey

One way:

=IF(A1="","",IF(A1=99%,"yes","no"))

The formula will return a null string, which displays as if the cell
were blank.
 
Top