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?

Rounding a group of numbers
 

hi!

select the range in question|
with your formula in the first cell
use CTRL+D

-via135



InNeed Wrote:
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?


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=521517