# I want the result of a formula to be rounded to the nearest 1,000

Copper Contributor

# 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?

5 Replies

# Re: I want the result of a formula to be rounded to the nearest 1,000

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)

# Re: I want the result of a formula to be rounded to the nearest 1,000

Thanks Hans.  I appreciate this.

# Re: I want the result of a formula to be rounded to the nearest 1,000

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.

# Re: I want the result of a formula to be rounded to the nearest 1,000

It should be

=ROUND(((G11*G6)*12),-3)

or, since the parentheses in the original formula are superfluous:

=ROUND(G11*G6*12,-3)

# Re: I want the result of a formula to be rounded to the nearest 1,000

That works. Thanks much.