Forum Discussion
How can I report numbers as ranged values?
I have a report calculating days until contract renewal. I'm wanting to report in a chart those values as ranges like 0-30 days, 31-89, 90-170, 180-364. For example the value in cell I3 is 149 d...
=IF(I3<30,"0-30",IF(I3<89,"31-89",IF(I3<170,"90-169",IF(I3<364,"170-364",""))))
This should do that for you.. then you can use a pivot chart to show what you want.