Complex IF formula with AND/OR

[insomned]

I have two columns, which I need to check are compatible. The first column has Y/N, and the other Agree/Disagree. With the formula, I added a new check column, to see which ones are compatible (ie have Y-Agree or N-Disagree) and which ones are not (for example have N-Agree). 

The IF formula I wrote is IF [AGR] = "Y" AND [Agreement] = "Agree" OR [AGR] = "N" AND [Agreement] = "Disagree" Then "Compatible" ELSE "Incompatible" ENDIF. 

This, however, works only for the second condition and returns the ones with Y-Agree as Incompatible. 

Suggestions how to fix this? Thanks a lot!! 🙂

[Luke_C · Accepted solution]

Hi @insomned 

Put each clause in parenthesis and it should work. 

IF ([AGR] = "Y" AND [Agreement] = "Agree")

OR ([AGR] = "N" AND [Agreement] = "Disagree")

Then "Compatible"

ELSE "Incompatible"

ENDIF

[insomned]

It worked, thank You so much!!! 🙂