You have right idea, but instead of doing 3 seperate checks, just do one.
Since you didn't give example of your formula...

=IF(ISERROR(YourFormula),0,YourFormula)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"jday" wrote:

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"?