Formula with multiple conditions (IF AND statements)

[janema]

I can figure out how to make this formula work. This is what I actually need it to do, but as I started writing the formula, I realized it wasn't going to work.

What I'm attempting:

If column AN equals "N" and column AL = "Hourly"
If column AN equals "E" and column AL = "Salary"

So, if both of the conditions above are met, then it's "OK," otherwise, it needs to be "CHECK"

I'm not sure if excel can actually do that, but thought I'd ask the experts on here. I started to write a IF AND formula, but just couldn't quite figure it out. Here was my initial attempt:

=IF(AND(AN57="N",AL57="Hourly", IF(AND(AN57="S",AL57="Salary","OK"),"CHECK"))

Please help! Thank you in advance for your guidance and expertise!

 

[Fluff]

How about

=IF(or(AND(AN57="N",AL57="Hourly"),AND(AN57="E",AL57="Salary")),"OK","CHECK")

 

[janema]

How about

=IF(or(AND(AN57="N",AL57="Hourly"),AND(AN57="E",AL57="Salary")),"OK","CHECK")

Yesss!!!! Thank you so much!!!

 

[Sufiyan97]

Try

=IF(AND(OR(AN57="N",AN57="E"),OR(AL57="Hourly",AL57="Salary")),"OK","CHECK")

 

[janema]

Try

=IF(AND(OR(AN57="N",AN57="E"),OR(AL57="Hourly",AL57="Salary")),"OK","CHECK")

Thank you!

 

[Fluff]

Yesss!!!! Thank you so much!!!

You're welcome & thanks for the feedback.