#DIV/0! error
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! |
#DIV/0! error
=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) wrote in message ... 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! |
#DIV/0! error
=IF(ISERROR(YourFormula),0,YourFormula)
Or, better, =IF(YourDenominator=0,0,YourNumerator/YourDenominator) Kind regards, Niek Otten Microsoft MVP - Excel wrote in message ... | 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! |
#DIV/0! error
On Jan 8, 2:47*pm, "Niek Otten" wrote:
=IF(ISERROR(YourFormula),0,YourFormula) Or, better, =IF(YourDenominator=0,0,YourNumerator/YourDenominator) 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? |
#DIV/0! error
On 8 Jan, 17:44, "Bob Phillips" wrote:
=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) wrote in message ... 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!- Hide quoted text - - Show quoted text - it worked! Thank you to you both for sending these along. |
#DIV/0! error
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,"-") -- Dana DeLouis "joeu2004" wrote in message ... On Jan 8, 2:47 pm, "Niek Otten" wrote: =IF(ISERROR(YourFormula),0,YourFormula) Or, better, =IF(YourDenominator=0,0,YourNumerator/YourDenominator) 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? |
#DIV/0! error
On Jan 8, 5:46*pm, "Dana DeLouis" wrote:
= Hi. *In Excel 2007, it's IFERROR. *(Here, "-" is display instead of an error.) =IFERROR(A1/B1,"-") 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.) |
All times are GMT +1. The time now is 10:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com