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

Why can't you just copy that formula down the column?

Pete

On Mar 8, 2:33*pm, mario <manima...@gmail.com> wrote:
> 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

On Mar 8, 5:11*pm, Pete_UK <pashu...@auditel.net> wrote:
> Why can't you just copy that formula down the column?
>
> Pete
>
> On Mar 8, 2:33*pm, mario <manima...@gmail.com> wrote:
>
>
>
> > 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

How WISE!!!! hehehe
M

On Mar 8, 5:11*pm, Pete_UK <pashu...@auditel.net> wrote:
> Why can't you just copy that formula down the column?
>
> Pete
>
> On Mar 8, 2:33*pm, mario <manima...@gmail.com> wrote:
>
>
>
> > 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

Thanks a lot!

You're welcome, Mario - thanks for feeding back.

Pete

On Mar 8, 4:14*pm, mario <manima...@gmail.com> wrote:
>
> Thanks a lot!