Leo,

I just found out that the worksheet that I was triying to use your formula
on is originated from an "external data" using Excel to query a database in
our server at work. And it doesn't work on it. But if I copy the results
(without the column headings) and paste them in a clean worksheet, it works.
I didn't know that. Do you know how to work around that?

"Leo Heuser" wrote:

One way:

=IF(AND(OR(D2={5,7}),OR(R2={0,1})),"No",IF(OR(AND( OR(D2={1,2,3,4}),R2=1),
AND(OR(D2={1,2}),R2=0)),"Yes","Not defined!"))

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Benny" skrev i en meddelelse
...
Need help with the following 2 situations involving data contained in 2
fields
to create a "Yes" or "No" field according to the following:

Situation #1

IF cell D2={1,2,3,4} and cell R2=1 then ="Yes"
And also if cell D2={1,2} and cell R2=0 then is also = "Yes"

Situation #2

Cell D2={5,7} and cell R2={0,1} then = "No"

--
Benny