#DIV/0! error

  • Thread starter Thread starter jesoldano
  • Start date Start date
J

jesoldano

Hi,
Is there any way to program a formula NOT to show the "#DIV/0!" error
when the formula is referencing a denomentor that is zero? Thanks!
 
=IF(denominator_cell=0,0,the_original_formula)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
=IF(ISERROR(YourFormula),0,YourFormula)

Or, better,

=IF(YourDenominator=0,0,YourNumerator/YourDenominator)

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
| Is there any way to program a formula NOT to show the "#DIV/0!" error
| when the formula is referencing a denomentor that is zero? Thanks!
 
=IF(ISERROR(YourFormula),0,YourFormula)
Or, better,
=IF(YourDenominator=0,0,YourNumerator/YourDenominator)
Click to expand...

The OP neglected to say what version of Excel he/she is using. Isn't
there another (better?) way in Excel 2007 to handle errors that avoids
having to duplicate the calculation of yourFormula or yourDenominator?
 
=IF(denominator_cell=0,0,the_original_formula)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)






- Show quoted text -
Click to expand...

it worked! Thank you to you both for sending these along.
 
Isn't there another (better?) way in Excel 2007 to handle errors...

Hi. In Excel 2007, it's IFERROR. (Here, "-" is display instead of an
error.)

=IFERROR(A1/B1,"-")
 
On Jan 8 said:
Hi.  In Excel 2007, it's IFERROR.  (Here, "-" is display instead
of an error.)
=IFERROR(A1/B1,"-")
Click to expand...

Thanks. I guess that would rile those who jump on me whenever I
suggest using ISERROR(), they arguing that it casts too wide a net and
masks other errors. (I see their point, and I don't disagree
strongly.)
 
Back
Top