Replace massively formulas with new formulas

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas 5
Excel Use COUNTIF across a range of cells with formulas 0
Column of formulas with some cells containing data derived from thereformula's I would like to find 2
Auditing formulas month over month 4
Excel VBA 1
Mid column sum formulas with varied ranges to sum 17
Question about editing formulas 1
How to Past cells with formulas not using "$" without changing ref 3

Top