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

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.

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

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

--
Kind regards,

Niek Otten

"UTmike" wrote in message ...
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.

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

one way

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

"UTmike" wrote in message
...
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.