Question relating to the OR function
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
|