Want to Combine 2 Separate and Opposite IF(AND Statements

[RachelGeno]

The two IF(AND statements I currently am using are the opposite of each other to compare column C to F and then F to C:
=IF(AND(C3="NOT FOUND",F3<>"NOT FOUND"),"CHECK","OK")
=IF(AND(F3="NOT FOUND",C3<>"NOT FOUND"),"CHECK","OK")

Is there any way of combining the two (maybe with an OR statement?) so that if C3="NOT FOUND" and F3<>"NOT FOUND" OR F3="NOT FOUND" and C3<>"NOT FOUND," then the formula will return "CHECK" and otherwise "OK"?

Thanks!

 

[63falcondude]

Try

=IF(OR(AND(C3="NOT FOUND",F3<>"NOT FOUND"),AND(C3<>"NOT FOUND",F3="NOT FOUND")),"CHECK","OK")

 

[RachelGeno]

Try

=IF(OR(AND(C3="NOT FOUND",F3<>"NOT FOUND"),AND(C3<>"NOT FOUND",F3="NOT FOUND")),"CHECK","OK")

That's perfect! I'll keep in mind putting the OR before the AND next time. Thanks so much.

 

[63falcondude]

That's perfect! I'll keep in mind putting the OR before the AND next time. Thanks so much.

You're welcome. Happy to help!

 

[Eric W]

Welcome to the forum.

Looks like you want "CHECK" if "NOT FOUND" occurs exactly once in those 2 cells. If so, try:

=IF((C3="NOT FOUND")+(F3="NOT FOUND")=1,"CHECK","OK")