If cell = 0

L

Lance

Hi There,

Can some one help. I am trying to work out how if you
have no information in a cell or it equals zero the
formula does not work.

Cheers
 
G

Govind

Hi,

Try using iserror function. For eg.

=IF(ISERROR((IF(A1>5,"Yes","No"))),"0",(IF(A1>5,"Yes","No")))

Regards

Govind.
 
Top