Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Options for DIV#/0
I have a formula that is VERY long and contains three nested components that
require a 'division' function. Any of these three 'divisors' could equate to zero, which of course will cause a DIV/#0 error. I cannot have this, because the result of this cell needs to be used in other formulas, which would just permeate the issue. However, I do not want to nest 3 additional "IF(ISERROR...." statements within an already unwieldy formula to cover the 3 division components. Is there any sort of function that can be incorporated at the start of my formula that basically says "If the final result of this formula is an error, then return a zero, otherwise return the calculated result"? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More than 2 IF options | Excel Worksheet Functions | |||
IF with 3 options | Excel Worksheet Functions | |||
how do I add more toolbar options to my right click options | Excel Discussion (Misc queries) | |||
FTP options | Excel Discussion (Misc queries) | |||
what are my options? | Excel Discussion (Misc queries) |