Sep 18 2023 08:36 AM
I can't seem to come up with a formula that will take the result of a formula in a cell and round it to the nearest thousand. Any suggestions?
Sep 18 2023 09:56 AM
Let's say the formula is in F2.
If you want the result in another cell, for example G2:
=ROUND(F2, -3)
If you want to round the result of the formula in F2 itself: change
=formula
to
=ROUND(formula, -3)
Sep 18 2023 02:08 PM
Sep 18 2023 02:27 PM
I must be missing something. For example, I have a cell where the formula is =((G11*G6)*12).
If I enter: =ROUND((G11*G6)*12),-3
I get an error message: Too few arguments for this formula.
What I want to do is round the result of the formula to the nearest thousand.
Sep 18 2023 02:30 PM
It should be
=ROUND(((G11*G6)*12),-3)
or, since the parentheses in the original formula are superfluous:
=ROUND(G11*G6*12,-3)
Sep 18 2023 02:32 PM