software

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.=IF(ISNA(YourFormula),0,YourFormula)

--
Kind regards,

Niek Otten

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

=IF(ISERROR((PUT YOUR EQUATION HERE))),quot;0quot;,(PUT YOUR EQUATION HERE)))

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