=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.

"Astroboy" wrote:

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...