|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 8th, 2008, 10:37 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
#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! 
|
|
#2
January 8th, 2008, 10:44 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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!
|
|
#3
January 8th, 2008, 10:47 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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!
|
|
#4
January 8th, 2008, 11:15 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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?
|
|
#5
January 8th, 2008, 11:23 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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.
|
|
#6
January 9th, 2008, 01:46 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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?
|
|
#7
January 9th, 2008, 03:36 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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.)
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
