You could do me a favor. The formula is can be reduced for Excel 2007. Are
you using that? Or do I have to provide two formulas, Excel 2007 and
previous versions?

Tyro

"FiluDlidu" wrote in message
...
Ho! I guess I must have explained something unclearly: I didn't want to
know
whether or not there was an argument that was an error, I only wanted the
function to return TRUE if any of its argument were true, regardless of
possible error value of other arguments, for I thought as soon as one of
its
arguments is true, the OR should also be true. And for the way I'm using
it,
the errors could be treated as false values...

The function I mentioned in my previous post was intended to return
something like the following:

A3: =or(if(iserror(A1=0),0,A1=0),if(iserror(A1=A1/A2),0,A1=A1/A2))

If A1=0 and A2=0, then A3 returns TRUE, because the first test is true
(the
truth of the second test is not necessary, and the fact it is an error
doesn't change the final result).
If A1=1 and A2=0, then A3 returns FALSE, because the first test is false
and
the second test is an error (treated as FALSE by the 0 value it was
assigned
in the second IF-test).

"Tyro" wrote:

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)