Hi Everyone,
I have a quick formula question. Column AD is an IF statement looking at two other columns (AB and AC). Each of these cells has a value N or Y. This is my current formula I'm working with in column AD.
=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.
Bookmarks