Rounding a group of numbers
In an excel file, I have a workout based on percentages and numbers.
Therefore for each cell, there is a forumla like this =D$70*(1-3*$B$49),
except with different numbers for every cell. That forumla comes up with the
number 62. I want to round every number to a multiple of 5. What formula can
I add to every cell that will do this.
I know the formula, =mround x number, 5, which rounds number x to a multiple
of 5
How can I apply that to a large number of cells?
|