How can I report numbers as ranged values?

[Dustin Vasichko]

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 days reports as 90-170 on a chart.  

Any ideas?

Thanks.

[#2]

=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.