Nested IF - Multiple Conditions question

[kslattery]

So, I have a problem I think is simple enough to solve, but I can't figure it out.

I'm looking for one column to identify whether or not the row falls into "Group A" or "Group B" based on two different sets of conditions.

Column A will either say "Red" or "Blue" while column B will have a number. For an entry to fall into Group A it must be red and the number must be >= 10. For Group B, it must be Blue and >=5.


I could do two separate formulas in different columns, i.e.: =IF((AND(B2>=10,A2="Red")),"Group A,"") , but I want to also identify Group B in the same formula.

[AliGW]

Try this:

=IF((AND(B2>=10,A2="Red")),"Group A,IF(AND(B2>=5,A2="Blue","Group B",""))

[Rev12]

Let say in

Cell A1:A2 Cell B1:B2 Cell C1:C2

Red 12 =IF(AND(B1>=10,A1="Red"),"Group A","Group B")
Blue 6 =IF(AND(B2>=10,A1="Red"),"Group A","Group B")

Hope it helps.

Rev12

[63falcondude]

Will there ever be an instance where column A is Red and column B is < 5? Or where column A is Blue and column B is < 10?

If so, try this:

=IF(AND(A2="Red",B2>=10),"Group A",IF(AND(A2="Blue",B2>=5),"Group B",""))

The formula will return blank if neither condition is satisfied.

[kslattery]

Will there ever be an instance where column A is Red and column B is < 5? Or where column A is Blue and column B is < 10?

If so, try this:

=IF(AND(A2="Red",B2>=10),"Group A",IF(AND(A2="Blue",B2>=5),"Group B",""))

The formula will return blank if neither condition is satisfied.

Yes -- sorry, forgot to mention that. But your solution works perfectly. I see where I was messing up before, too. Still getting used to Nested IFs


edit: Thank you to AliGW as well!

[63falcondude]

Glad we could help.