Hi,

I am using the below formula to make the range of numbers in Column 1 (R) fall into certain buckets in column 2 (S).
The numbers range from 0-30.
I had originally pivoted them and them grouping them by intervals of 5. However now the data is needed in the below format
0 =
1-3 =
4-5 =
6-10 =
11-15 =
16-20 =
>20 =

The last four is easy. Its the second and 3rd interval that is throwing me from using a pivot.

The formula seems to work for some and throws errors for others.

=IF(R3="0","New",IF(R3>0<4,"1-3","4-5"),IF(R3>5<11,"6-10","11-15"))

Can you please help me.

Thanks
GV