I have a table of cells with integer numbers (see this file and the table called ExampleTable1).
I want to convert the table to table with integers, which are rounded up to the smallest number, bigger then the input and divisible by 50 (see ExampleTable3).
For example I have number
123. I want to be converted to
150, since it is the smallest integer bigger than
123 and divisible by
Here is, however, the tricky part. I can easily use
=roundup(123/50;0)*50 and It will return
150 (see ExampleTable2).
Why don't I use roundup in a copy of my table?
(1) The actual table that I want to "roundup" is huge with some texts and formatting so I don't want to change them inadvertently.
(2) There are some formulas, which go very incorrect, if I round their cells up. See NoNoNo row.
(3) I will gladly learn something new, if there is a way to solve my problem the way I describe it.
(4) I am too lazy to write the roundup formula and drag it all over the copy table, because it is hundreds of rows and columns.
Is there a way to use for example the Right Click -> Format Cells -> The "Custom" category and make it to automatically roundup the values the way I ask here?
Is there a way to do it in other fast way, like a macro or something? I am really very pretty bad at Visual Basic, so please be sure, that if you are gonna give me a VBA solution, I will ask you some irritating stuff back, for the fact that I have probably not gotten it correctly.
Thank you all in advance.