Multiple if and

Occasional Visitor

I would like one cell to determine 4 AND scenarios and return a specified result if true. I’m unable to get past 2 AND statements in one formula. Can anyone help?

1 Reply


Perhaps you meant




or (if you have Excel 2019 or later)




Please note that the formula will return FALSE if C2=C5 and/or D2=D5 since your conditions don't include that situation.