IF Statement

[Badvgood]

What I need to do is in cell S2 a formula that says....

if R2 is blank then do nothing

If R2 has the word Yes in it then look at cell Q2

if Q2 has the word Yes in it then display the word Yes

if Q2 has the word No in it then display the word No

Help please

Thanks BVG

[Roger Govier]

What I need to do is in cell S2 a formula that says....

if R2 is blank then do nothing

If R2 has the word Yes in it then look at cell Q2

if Q2 has the word Yes in it then display the word Yes

if Q2 has the word No in it then display the word No

Help please

Thanks BVG

Hi

Please Login or Register  to view this content.

[Badvgood]

=if(R2="","",If(R2="Yes",IF(OR(Q2="Yes",Q2="No"),Q2,"")))

Worked. Than you.

Regards BVG