| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error Terms
How can I get an error term, such as #DIV/0!, to display as just a zero? Thanks
-- Michael Gudyka St. Charles, IL |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Error Terms
One way:
Instead of =A1/B1 use =IF(B1=0,0,A1/B1) In article , Michael Gudyka wrote: How can I get an error term, such as #DIV/0!, to display as just a zero? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Error Terms
=if(iserror(yourformula),0,yourformula)
Michael Gudyka wrote: How can I get an error term, such as #DIV/0!, to display as just a zero? Thanks -- Michael Gudyka St. Charles, IL -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Error Terms
I really discourage using iserror - it ignores too many "unexpected"
errors (displaying a valid, but incorrect value - hmmm...where have we heard about *that* lately??). And since it calls fewer functions, this is actually more efficient: =IF(yourdenominator=0, 0, yourformula) In article , Dave Peterson wrote: =if(iserror(yourformula),0,yourformula) Michael Gudyka wrote: How can I get an error term, such as #DIV/0!, to display as just a zero? Thanks -- Michael Gudyka St. Charles, IL |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Error Terms
On the other hand, =iserror() does help if either the numerator or denominator
cells contain text. And personally, I think returning a 0 when the divisor is 0 is just another way to hide an error (expected or unexpected). == I wasn't trying to sound too argumentative. I understand your point. JE McGimpsey wrote: I really discourage using iserror - it ignores too many "unexpected" errors (displaying a valid, but incorrect value - hmmm...where have we heard about *that* lately??). And since it calls fewer functions, this is actually more efficient: =IF(yourdenominator=0, 0, yourformula) In article , Dave Peterson wrote: =if(iserror(yourformula),0,yourformula) Michael Gudyka wrote: How can I get an error term, such as #DIV/0!, to display as just a zero? Thanks -- Michael Gudyka St. Charles, IL -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Error Terms
And just to add, I've found that my co-workers were much more interested in the
"prettiness" of the worksheet than the accuracy. <gd&r Dave Peterson wrote: On the other hand, =iserror() does help if either the numerator or denominator cells contain text. And personally, I think returning a 0 when the divisor is 0 is just another way to hide an error (expected or unexpected). == I wasn't trying to sound too argumentative. I understand your point. JE McGimpsey wrote: I really discourage using iserror - it ignores too many "unexpected" errors (displaying a valid, but incorrect value - hmmm...where have we heard about *that* lately??). And since it calls fewer functions, this is actually more efficient: =IF(yourdenominator=0, 0, yourformula) In article , Dave Peterson wrote: =if(iserror(yourformula),0,yourformula) Michael Gudyka wrote: How can I get an error term, such as #DIV/0!, to display as just a zero? Thanks -- Michael Gudyka St. Charles, IL -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Invoice due; Payment terms | Excel Discussion (Misc queries) | |||
| how do i look up terms in excel? | Excel Discussion (Misc queries) | |||
| Terms customer is using-What do they mean? | Excel Discussion (Misc queries) | |||
| Calculate terms in a Series | Excel Worksheet Functions | |||
| Please Explain in Lamen's Terms | Excel Worksheet Functions | |||
Linear Mode
