View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
mz mz is offline
external usenet poster
 
Posts: 40
Default OR function produces incorrect result

I am testing the "OR" function and it seems to produce a false result even
when only one of two logical arguments is false (that is, it is acting like
the AND function that requires all arguments to be true).

Here is the formula I wrote:

Cell D2 is 50
Cell D3 is 3

=IF(OR(D2=6,D3=3),"OK","No good")

The result is "No good" even though the second argument is true.


--
MZ