Perhaps =ISERROR(OR(cond_1,cond-2,....cond_N))
This returns TRUE if any of the OR conditions is an error, FALSE if not.

Tyrp

"FiluDlidu" wrote in message
...
Now that you made me think about it...

=OR(if(iserror([test1]),0,[test1],if(iserror([test2]),0,[test2],...)

That solved my problem, even though not in a very elegant way...

Cheers.

"Tyro" wrote:

=OR(TRUE,FALSE,FALSE,FALSE) evaluates as TRUE;
=OR(TRUE,FALSE,FALSE,#ERROR)
evaluates as #ERROR. Perhaps you want to enclose your formula in an
ISERROR
function (pre-Excel 2007) or IFERROR (Excel 2007)