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

"AA Arens" <[email protected]> wrote in message
news:[email protected]...
> 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]

Or:

=ROUND(A1,-3)

Biff

"Biff" <[email protected]> wrote in message
news:[email protected]...
> Hi!
>
> Try this:
>
> =ROUND(A1/1000,0)*1000
>
> Biff
>
> "AA Arens" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>
>

[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 wrote:
>
> 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

--

Dave Peterson

[AA Arens]

Thanks all for your help. I choosed option 2.

Bart

Dave Peterson wrote:
> 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 wrote:
> >
> > 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
>
> --
>
> Dave Peterson

[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

"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> 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 wrote:
>>
>> 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
>
> --
>
> Dave Peterson