View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default OR function produces incorrect result

As Eduardo said, more than likely D3 is formatted as text. A quick test:
change your formula to
=IF(OR(D2=6,D3="3"),"OK","No Good")
if you get OK, then D3 is definitely formatted as text or the number has a
single apostrophe in front of it, forcing it to be treated as text.

"Eduardo" wrote:

Hi,
The formula is correct and works fine, check if the number in D3 is not
formated as a text

"MZ" wrote:

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