If Statement checking Dual Criteria

[jharvey87]

Hi Everyone,

Hoping someone might be able to help me with this. I'm having a bit of trouble writing a formula that is checking two cells and return 4 possible responses.

My formula resides in column AD. It is referencing columns AB and AC. Each of these can have a value of N or Y. The possible outcomes I want in AD are:
- Yes (Both AB and AC have a "Y")
- G/L Missing (AB=N ; AC=Y)
- Auto Missing (AB=Y ; AC=N)
- G/L and Auto Missing (AB=N ; AC=N)

My formula currently is:

=IF([@[General Liability Endorsements]]="","",IF([@[General Liability Endorsements]]<>"Y","GL Missing",IF($AC67<>"Y","Auto Missing","Yes")))

Cell works fine, beyond the fact when both columns AB and AC are "N". As of right now, since it first looks at cell AB, it would show "GL Missing". Would it be possible to create a 3rd option, if both cells are equal to "N" in columns AB and AC, then it would show "GL and Auto Missing". I believe this can be done with an AND statement, but I'm a bit lost.

Any help would be greatly appreciated.

[mo4391]

=IF(AND(AB1="Y",AC1="Y"),"Yes",IF(AND(AB1="N",AC1="Y"),"G/L Missing",IF(AND(AB1="Y",AC1="N"),"Auto Missing",IF(AND(AB1="N",AC1="N"),"G/L and Auto Missing",""))))

[Shareez Saleem]

=IF(AND(AB1="Y",AC1="Y"),"Yes",IF(AND(AB1="N",AC1="Y"),"G/L Missing",IF(AND(AB1="Y",AC1="N"),"Auto Missing",IF(AND(AB1="N",AC1="N"),"G/L and Auto Missing",""))))

[jharvey87]

This worked perfectly. Thank you Mo4391.