Is it possible to treat and display a #div/0 error as a zero?
 

I have an output worksheet that relies partially on the the results of
formulas from linked worksheets. I want to be able provide users the option
of not inputing into every other linked worksheet, and thus treating any
#div/0 error as a simple zero value instead. Is there any way to do this
tools, etc?

Is it possible to treat and display a #div/0 error as a zero?
 

Maybe you meant:
=IF(ISERROR(<yourformula),0,<yourformula)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,400 Files:361 Subscribers:58
xdemechanik
---
"Andrew" wrote:
I have an output worksheet that relies partially on the the results of
formulas from linked worksheets. I want to be able provide users the option
of not inputing into every other linked worksheet, and thus treating any
#div/0 error as a simple zero value instead. Is there any way to do this
tools, etc?

Is it possible to treat and display a #div/0 error as a zero?
 

On Thu, 2 Oct 2008 16:39:00 -0700, Andrew
wrote:

I have an output worksheet that relies partially on the the results of
formulas from linked worksheets. I want to be able provide users the option
of not inputing into every other linked worksheet, and thus treating any
#div/0 error as a simple zero value instead. Is there any way to do this
tools, etc?



To change div/0 errors to 0, but leave other errors unchanged, you could use:

=IF(ISERROR(your_formula),IF(ERROR.TYPE(your_formu la)=2,0,your_formula),your_formula)

If you have XL2007:

=IFERROR(your_formula,IF(ERROR.TYPE(your_formula)= 2,0,your_formula))

--ron

Is it possible to treat and display a #div/0 error as a zero?
 

I believe this is what I need . Thank you.

"Max" wrote:

Maybe you meant:
=IF(ISERROR(<yourformula),0,<yourformula)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,400 Files:361 Subscribers:58
xdemechanik
---
"Andrew" wrote:
I have an output worksheet that relies partially on the the results of
formulas from linked worksheets. I want to be able provide users the option
of not inputing into every other linked worksheet, and thus treating any
#div/0 error as a simple zero value instead. Is there any way to do this
tools, etc?

Is it possible to treat and display a #div/0 error as a zero?
 

Welcome, Andrew
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,400, Files:361, Subscribers:58
xdemechanik
---
"Andrew" wrote in message
...
I believe this is what I need . Thank you.