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" <Benny@discussions.microsoft.com> skrev i en meddelelse
news:E1D56A82-448E-49FC-BC71-EF10E2878D88@microsoft.com...
> 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