View Single Post
  #1   Report Post  
Benny
 
Posts: n/a
Default 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