View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FiluDlidu FiluDlidu is offline
external usenet poster
 
Posts: 66
Default 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