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
|