View Single Post
  #3   Report Post  
Trevor Shuttleworth
 
Posts: n/a
Default

TazzyDal

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

Regards

Trevor


"TazzyDal" wrote in message
...

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" or
no" are returned, the cell would remain blank......


--
TazzyDal