M
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 of the existing ones.
ex. cell C5 = A1/B1
and I want to massively apply for all cells in a row the formula:
=ROUND(A1/B1,3)
I need the accuracy of the values to be at the 3rd decimal and not
just the appearance of the cells.
I also need to avoid VB programming.
Anyone who can help?
THanks
M
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 of the existing ones.
ex. cell C5 = A1/B1
and I want to massively apply for all cells in a row the formula:
=ROUND(A1/B1,3)
I need the accuracy of the values to be at the 3rd decimal and not
just the appearance of the cells.
I also need to avoid VB programming.
Anyone who can help?
THanks
M