Nested IF AND OR Function

[mrcortina1217]

Hello -
I'm trying to evaluate the contents of two cells with 4 possible values.
I3 can contain either Active or Inactive
J3 can contain either YES or NO

IF I3="Active" AND J3="YES"
OR IF I3="Inactive" AND J3="NO"
THEN "Match"
ELSE "No Match"

I've tried several combinations and am not getting the results I expect - I'm looking for situations where either of these combinations do not exist.
For example, in the test row, I3=Active and J3=Yes ... so I would expect my formula to return "Match" however it returns "No Match"
=IF(AND(I3="Active",J3="YES",OR(AND(I3="Inactive",J3="NO"))),"Match","No Match")
Test rows containing other combinations of the variables also return "No Match".

1st Variable	2nd Variable	Results	Expected Results
Active	YES	No Match	Match
Inactive	NO	No Match	Match
Active	NO	No Match	No Match
Inactive	YES	No Match	No Match

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

I'm stumped.

Many thanks in advance.

 

[dreid1011]

It looks like your OR is in the wrong place. Give this a try.

=IF([COLOR="#0000FF"]OR(AND(I3="Active",J3="YES"),AND(I3="Inactive",J3="NO"))[/COLOR],"Match","No Match")

 

[mrcortina1217]

FANTASTIC! Something so simple as a misplaced OR.

 

[dreid1011]

Glad it solved the problem.