Is there a way to write an equation that ignores cells that have .

[UTmike]

I am trying to write an equation that will ignore cells that have a result
from a previous equation of #N/A. Or is there a way to write an equation
that if the answer is #N/A, the result will be zero.
Thanks.

 

[Niek Otten]

=IF(ISNA(YourFormula),0,YourFormula)

 

[PH NEWS]

one way

=IF(ISERROR((PUT YOUR EQUATION HERE))),"0",(PUT YOUR EQUATION HERE)))