# Excel – Categorize the data into 3 groups

microsoft excel

I want to use a formula which allows me to categorize my data into 3 groups.
I want:

• Units shipped <100 to be called Group "A"

• Units shipped Between 100-999 to be group "B"

• Units Shipped >1000 to be group "C"

I have tried:

IF(Sales<100,"A", IF(AND(Sales>=100, Sales<=999, "B", IF(Sales>1000, "C",0)))


But it keeps coming up with the:

we found a problem with this formula

error message and I can't work out what is wrong with the formula.