I often use the ISERROR function to wrap around a formual that may have
a an error in it. I use if nested in an If stmt to say if the formual
generates an error, then produce a zero value otherwise, do I want I
want it to. For example:

IF(ISERROR(A1/B1),0,A1/B1)

Problem is that you have to type in the fist part of the formual A1/B1
again at the end of the IF stmt. This is really a pain if the condition
is ver large:

=IF(ISERROR(IF(Inputs!$G$550 =
"Denominator",(Statements!H101+Statements!H102 )/(Statements!H101+Statements!H102+Statements!H106), 1)),0,IF(Inputs!$G$550
=
"Denominator",(Statements!H101+Statements!H102 )/(Statements!H101+Statements!H102+Statements!H106), 1))

Is there a formual or userdefined function that acts like an iserror
wrapped in an If stm that will allow me to not repeat the formula? It
would look like this:

Iserror2(condition,result if condition is false)
or
Iserror2(A1/B1,0)
or
Iserror2(IF(Inputs!$G$550 =
"Denominator",(Statements!H101+Statements!H102 )/(Statements!H101+Statements!H102+Statements!H106), 1)),0)

Does anybody know if this exists or hoe to build this in VBA?

thnx


--
ExcelMonkey
------------------------------------------------------------------------
ExcelMonkey's Profile: http://www.excelforum.com/member.php...fo&userid=5221
View this thread: http://www.excelforum.com/showthread...hreadid=277709