How do I round to the nearest thousand?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok, I know the round function is great to use with DECIMAL rounding but I
need to round my number to the next highest thousand (meaning 35,455 should
be 36,000)...anyone know how I can accomplish this?

Any help is much appreciated!
 
Marie

I'm not familiar with an "elegant" function to do so, but you could use a
brute force method:

* divide by 1000
* use Int() to convert to an integer (or Round() to no places)
* multiply by 1000

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top