How to round values to the nearest 1000?

[AA Arens]

How to round values to the nearest 1000?

Like: 12,549,235 > 12,549,000
Like: 12,549,735 > 12,550,000

According to Help I should use =ROUND(P9,3-LEN(INT(P9))) but the result
is not what I want.

Bart
Excell 2003

 

[Biff]

Hi!

Try this:

=ROUND(A1/1000,0)*1000

Biff

 

[Biff]

Or:

=ROUND(A1,-3)

Biff

Hi!

Try this:

=ROUND(A1/1000,0)*1000

Biff

 

[Dave Peterson]

And one more if you have the analysis toolpak loaded:

=MROUND(A1,1000)

I'd use Biff's second answer, but =mround() may be interesting to review.

You may also want to look at =floor() and =ceiling() (just to know that they
exist).

 

[AA Arens]

Thanks all for your help. I choosed option 2.

Bart

 

[Biff]

I'd use Biff's second answer

I'm so used to the first method that I overlook the "intended syntax". I
think the first method is more intuitive, though. (not taking into account
MROUND)

Biff