Apply a formula in cell with a formula massively

[mario]

Hi there,

would like to get your input/hints on how to solve the following:

In a series of cells in a row, I already have a formula calculating a
division among two other columns.

The rows are many (more than 500).

But now I need to apply a ROUND formula, on top the existing ones.
ex. cell C5 = A1/B1
and I want to massively for all rows/cells to make them: ROUND(A1/
B1,3)

Anyone who can help?
THanks
M

 

[Bob Greenblatt]

Hi there,

would like to get your input/hints on how to solve the following:

In a series of cells in a row, I already have a formula calculating a
division among two other columns.

The rows are many (more than 500).

But now I need to apply a ROUND formula, on top the existing ones.
ex. cell C5 = A1/B1
and I want to massively for all rows/cells to make them: ROUND(A1/
B1,3)

Anyone who can help?
THanks
M

Simply place the formula in one cell and then drag (using the little
square in the lower right corner of the cell) to the remaining cells.

 

[CyberTaz]

Do you actually want the calculated results rounded to 3 decimals or do you
simply want them to display & print 3 decimal places of accuracy? If the
latter just select the cells containing the calculations & change the
decimal formatting of the cells.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[mario]

Thank you both for your interest....but I want the accuracy to the 4rd
digit decimal and not the appearance.
But the issue is that I need to make this work as a template.
This means that the current formulas have to change for future use as
well.....so the new formula with the ROUND needs to be added on top
the existing ones....in several cells.

Any other idea? avoiding VB programming of course
M

 

[CyberTaz]

Select the first cell containing the formula then key Shift+Command+Down
Arrow & go to the Edit> Fill> Down command.

Regards |:>)
Bob Jones
[MVP] Office:Mac