Testing for evaluation error and specifying alternative value, all without repeating myself.

[SwordAngel]

How do I test for an evaluation error and specify an alternative value without repeating myself?

The only way I know is to use "if(iserror([...]),[...])", which is tedious and forces me to repeat myself (in "iserror()" and at the last argument of "if()").

Is there a simpler syntax like in some general purpose programming languages? E.g. "somefunction()?«alternate value»"

 

[VoG]

If you have Excel 2007 or later you can use

=IFERROR(formula, value if error)

 

[SwordAngel]

Wow. That was quick!

You just made my day better.

Thanks, VoG.