Forum Discussion
I want the result of a formula to be rounded to the nearest 1,000
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?
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)
