| 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? |
| 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) | |||
Threaded Mode
