Hi Folks,
I am trying to create an IF ELSE formula but don't know how to write it as it has a lot of conditions .
Here's the crazy idea.
If A1 = "A" or "T" and B1 = "A" or "T" - OR A1 = "O", C1 = "List" and B1 = "Admin" - OR A1 = "O", C1 = "List", B1 = "Admin" and D1 is not equal to "Q","Z","Y" or "L" - OR A1 = "G" and B1 = "Admin" - OR A1 = "P" or "Q" and B1 = "P" or "Q" - OR A1 = B1 - THEN "SAME", ELSE "DIFFERENT"
Essentially, the text must read 'SAME" if these criteria are being matched or "DIFFERENT " is these conditions are not being met.
Please help me if it is possible to write such a formula.
Any Help is greatly appreciated.
Thank you
Bookmarks