Creating an IF/ELSE formula with multiple criteria - Nested IF/ELSE?

**Doofus1** · 08-21-2014, 07:00 PM

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

**Danerida** · 08-21-2014, 07:51 PM

Try:
=IF(OR(AND(OR(A1="A",A1="T"),OR(B1="A",B1="T")),AND(A1="O",C1="List",B1="Admin"),AND(A1="O",C1="List",B1="Admin",OR(D1<>"Q",D1<>"Z",D1<>"Y",D1<>"L")),AND(A1="G",B1="Admin"),AND(OR(A1="P",A1="Q"),OR(B1="P",B1="Q"))),"SAME","DIFFERENT")

**Doofus1** · 08-21-2014, 08:33 PM

Thank you.
I will test this in a short while

**gak67** · 08-21-2014, 07:55 PM

It's hard to follow your logic as it is written. However, you can nest OR and AND functions. The first part of your formula might be =IF(AND(OR(A1="A",A1="T"),OR(B1="A",B1="T"))...which says that: if (A1 = "A" or A1 = "T") and (B1 = "A" or B1 = "T")

I hope that helps.

**Doofus1** · 08-21-2014, 08:34 PM

Thank you.
Yes. there are a lot of crazy conditions

Creating an IF/ELSE formula with multiple criteria - Nested IF/ELSE?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Creating an IF/ELSE formula with multiple criteria - Nested IF/ELSE?

Re: Creating an IF/ELSE formula with multiple criteria - Nested IF/ELSE?

Re: Creating an IF/ELSE formula with multiple criteria - Nested IF/ELSE?

Re: Creating an IF/ELSE formula with multiple criteria - Nested IF/ELSE?

Re: Creating an IF/ELSE formula with multiple criteria - Nested IF/ELSE?

Thread Information

Users Browsing this Thread

Similar Threads

Return the value of a cell/multiple criteria using nested INDEX, MATCH, IF array formula

[SOLVED] Need help creating an IF formula to add a percentage based on multiple criteria

[SOLVED] creating a count formula that looks at multiple criteria

Creating a nested If function with multiple vlookups

Help with creating macro/formula based on cells meeting multiple criteria

Bookmarks

Bookmarks

Posting Permissions