Rounding a number to the next highest thousand

[Jeff Abraham]

How do you round a number up to the next highest thousand? I've tried the Round function but it doesn't do what I want it to do. I tried putting in a negative precision number but no luck. Here's an example of what I need:

Number entered: 54,001.30

Rounded number result: 55,000.00

Number entered: 38,202.03

Rounded number result: 39,000.00

Thanks for the help!

[danjacoby]

Round(Number + 500, -3)

By adding 500 to the original number, it'll round up to the next 1,000.

[Lee Smith]

Hi Jeff,

Try this one:

Case(1000, Round(Number / 1000, 0) * 1000, "")

It seems to work in my little file. You will have to use Number format of the field to get the .00.

HTH

Lee

[Ugo DI LUCA]

Round(Int(amount)+1000);-3) if you want that 4,000 becomes 5,000 and 3999 becomes 5,000

[danjacoby]

Jeff --

With one minor exception, don't listen to these others; my original answer is accurate and elegant.

The exception? If you want the number to show two decimal places, you do indeed have to use format:number.