Nested IF AND OR statement help

Hey y'all!

Firstly thank you for the help!

I am trying to create an if statement to test a set of conditions. I want to return "Pass" or "Check" between products in two different systems where A=A, B=B, but A can also = C, A=C is what I can't figure out.

Excel spreadsheet with example is attached.

Thank you!
AuditMaster1000

Try it this way in D8:

=IF(OR(B8=C8,B8&C8="AC",C8&B8="AC"),"Pass","Check")

then copy down.

Hope this helps.

Pete

=IFS(B9=C9,"Pass",AND(B9="A",C9="C"),"Pass",TRUE,"Check")

Ahhhh I hadn't even thought of using'IFS'! Thank you for that.

Also, if anyone else comes along with a similar question. I also solved it after a bit more tweaking using the following: =IF(OR(B8=C8,OR(AND(B8="A",C8="C"))),"Pass","Check")

Originally Posted by AuditMaster1000

Also, if anyone else comes along with a similar question. I also solved it after a bit more tweaking using the following: =IF(OR(B8=C8,OR(AND(B8="A",C8="C"))),"Pass","Check")

That formula would do the same thing as this one:
=IF(OR(B8=C8,B8&C8="AC"),"Pass","Check")

Mine also checks for B8="C" and C8="A", which I thought would be another acceptable combination.

Pete