Try this (it's ugly)

=IF(AND(OR(D2=1,D2=2,D2=3,D2=4),R2=1),"YES",IF(AND (OR(D2=1,D2=2),R2=0),"YES",IF(AND(OR(D2=5,D2=7),OR (R2=0,R2=1)),"NO",NA())))

It will put NA() in if nothing matches.

"Benny" wrote:

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