ExcelBanter - Rounding up numbers in a pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Rounding up numbers in a pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/197635-rounding-up-numbers-pivot-table.html)

time conversion[_2_]

Rounding up numbers in a pivot table

I have a long column of numbers in a pivot table.....all whole
numbers....that I would like to round up to the nearest 5.....ie:

52 = 55
68 = 70
33 = 35

any suggestions?

All times are GMT +1. The time now is 11:31 AM.