| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A line in the middle of my doc causes Word to treat one doc as two | Excel Discussion (Misc queries) | |||
| how to treat string value as a number | New Users to Excel | |||
| How do I treat row 1 in my worksheet as a header for each page? | Excel Worksheet Functions | |||
| Have Excel treat documents as Word does | Excel Discussion (Misc queries) | |||
| how to treat rows as one record | Excel Discussion (Misc queries) | |||
Linear Mode
