If cell = 0

[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

 

[Govind]

Hi,

Try using iserror function. For eg.

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

Regards

Govind.

 

[Frank Kabel]

Hi
try
=IF(OR(A1="",A1=0),"",your_formula)