=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%"))))
[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]
I am looking for a way to put these into ranges of 0-25%, 25-50%, 50-75%,75-100%
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%"}) |