Help with creating Formula again
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
|