Hi All,
I have a set of numbers that increase in increments varying by 5 at the start with the interval becoming larger in steps as the numbers get higher. Users are able to input a figure into a cell and a worksheet change event should round the figure up based on the set increments in the list. The first 20 increments look like this - 5, 10, 15, 20, 25, 50, 100, 150, 200, 250, 300, 350, 400, 450, 500, 550, 600, 650, 700, 750, etc. If the user were to input 12, the worksheet change event would round the number between increments 10 and 15 resulting in a rounded figure of 10.
13 would result in 15
75 would result in 100
324 would result in 300, etc.
I can use ROUNDUP for regular integer intervals but am struggling to find a simple way to roundup between set figures for the worksheet change event. I have attached a workbook with the full increment set. The macro in its base form is:
Incremental Rounding.png
Any assistance would be greatly appreaciated!
Many thanks,
David
Bookmarks