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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
one way

=IF(ISERROR((PUT YOUR EQUATION HERE))),"0",(PUT YOUR EQUATION HERE)))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Equation Editor & Excel 2
Microsoft Equation 3.0 5
sumproduct issues 1
Calling name of Sheet as a Variable? 1
Equation Efficiency? 1
when setting a cell to equal a blank cell it displays 0 2
Function writing help 2
Standard Error of the Estimate 2

Back
Top