Round to nearest thousand

[kayek]

How do you round a number to the nearest thousand.

For Example:
round 96,452 to 96,000
round 96,500 to 97,000

 

[PHV]

To avoid the "bank rounding" behaviour of the Round function:
1000*((yourNumber+500)\1000)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[stix4t2]

PHV,

I thought you had to convert the number to integer before multiplying.

1000*clng((yourNumber+500)\1000)

 

[PHV]

stix4t2:
1000*((yourNumber+500)[!]\[/!]1000)
The result of an integral division is already integral ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886