Putting Numbers into Ranges

[mhendo1]

I am looking for help

I have a around 50 different percentages which all vary from 15% - 100%

I am looking for a way to put these into ranges of 0-25%, 25-50%, 50-75%,75-100%

and then reflect this onto a chart.

Can someone help out?

regards,

 

[MandeepBaluja]

Put this formula

=IF(AND(A2>=0%,A2<=25%),"0-25%",IF(AND(A2>25%,A2<=50%),"25-50%",IF(AND(A2>50%,A2<75%),"50-75%",IF(AND(A2>=75%,A2<=100%),"75-100%"))))

adjacent to your data draw a pivot and make a chart, you can also use pivot table grouping to group percentage in certain intervals.

 

[MandeepBaluja]

Small change

[TABLE="width: 111"]
<tbody>[TR]
  [TD="class: xl63, width: 111"]IF(AND(A2>=0%,A2<=25%),"0-25%",IF(AND(A2>25%,A2<=50%),"25-50%",IF(AND(A2>50%,A2<=75%),"50-75%",IF(AND(A2>75%,A2<=100%),"75-100%"))))[/TD]
[/TR]
</tbody>[/TABLE]

 

[FormR]

I am looking for a way to put these into ranges of 0-25%, 25-50%, 50-75%,75-100%

Couple of other options depending on where you want to place the percentages that are exactly 25%, 50% or 75%

Excel 2013
	A	B	C
2	15%	0-25%	0-25%
3	25%	0-25%	25-50%
4	27%	25-50%	25-50%
5	50%	25-50%	50-75%
6	51%	50-75%	50-75%
7	75%	50-75%	75-100%
8	85%	75-100%	75-100%
Sheet2

Cell Formulas
Range	Formula
B2	=CHOOSE(ROUNDUP(A2/0.25,0),"0-25%","25-50%","50-75%","75-100%")
C2	=LOOKUP(A2,{0,0.25,0.5,0.75},{"0-25%","25-50%","50-75%","75-100%"})