Leo,
I believe I was giving you the wrong cell reference before. I tried your
formula at home and it worked fine. Thanks a lot for your help.

"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