On Sun, 27 Apr 2008 09:27:00 -0700, FiluDlidu
wrote:

Hi all,

I half-noticed a long while ago that whenever there is an error within the
arguments to test in a logical function, the final result will also be an
error.

But it just stroke me today that if I have something like...
A1: 1
A2: =OR(A1=1,A1=2/0)
...A2 will return an error despite the fact the first argument returned
TRUE, which in any case should validate the OR... shouldn't it?

Is there a trick to go around this problem without stacking functions?

Thanks for any input,

Feelu

From HELP:

The arguments must evaluate to logical values such as TRUE or FALSE, or in
arrays or references that contain logical values.

If an array or reference argument contains text or empty cells, those values
are ignored.

Seems the arguments can be text, empty, or a logical value. Since your error
is none of the above, it does not fall within the acceptable definition for an
OR argument.

Whether is "should" work is a matter you need to take up with MS :-(
--ron