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.