Newbie Q-Formular for this situation...????

A

Astroboy

Hello all...


If...

B2=A
C2=B
D2=C

Then on G5 show "YES"


If...

B2=B
C2=C
D2=A

Then on G5 show "NO"

....

B2,C2,D2 can have one of the A,B,C and base on that G5 showing the word...


Any help will be great... and thank you...
 
S

Sheeloo

=IF(AND(B2="A",C2="B",D2="C"),"Yes",IF(AND(B2="B",C2="B",D2="C"),"No","Neither"))

It will return 'Neither' if both conditions are not met.
 
Top