View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
InNeed
 
Posts: n/a
Default 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?