I have to separate my data in category, say for example:
Category Minimum Maximum
A -100 -20
B -20 0
C 0 +20
D +20 +100
So if one data point is -50, it belongs to Category A.
One solution is to use nested IFs:
=IF(A1<-20,"A",IF(A1<0,"B",IF(A1<20,"C","D")))
But when the number of categories increases it becomes quite messy. Is there a better way to achieve the same?