I was not familiar with this new "IFERROR" function in Excel 2007. This is
exactly what I needed! The ISERROR version would work too, but the formula
is 3 wrapped lines long, so to reference that formula twice within the cell
would have been TOO MUCH!! Thanks for your help.

"Elkar" wrote:

If you're using Excel 2007, then you can use the IFERROR function:

=IFERROR(your_formua,"")

For older versions of Excel, you'll need to use the "unwieldly" approach.
But you don't have to repeat it 3 times, just once.

=IF(ISERROR(your_formula),"",your_formula)

HTH
Elkar


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