Forum Discussion
Dustin Vasichko
Aug 09, 2018Copper Contributor
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 days reports as 90-170 on a chart.
Any ideas?
Thanks.
1 Reply
- Philip WestIron Contributor
=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.