Forum Discussion

Dustin Vasichko's avatar
Dustin Vasichko
Copper Contributor
Aug 09, 2018

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 West's avatar
    Philip West
    Iron 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.

Resources