rounding #'s

H

HiLo

I am trying to round a number to the nearest 1,000 place. For example 53,750 up to 54,000. Any help would be great.
 
V

Van T. Dinh

?CLng(53750/1000)*1000
54000

--
HTH
Van T. Dinh
MVP (Access)



HiLo said:
I am trying to round a number to the nearest 1,000 place. For example
Click to expand...
53,750 up to 54,000. Any help would be great.
 
T

Tim Ferguson

I am trying to round a number to the nearest 1,000 place. For example
53,750 up to 54,000. Any help would be great.
Click to expand...

= Int(SomeNumber/1000 + 0.5) * 1000

Hope that helps


Tim F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round number subject to it's value 1
rounding a number up to a certain ending digit 6
rounding up to the nearest 1000 1
Organizing a group of notebooks 0
Int rounding down (calculated) whole numbers 2
Rounding 3
Mail Merge Switch - Dollars to Words 0
how to divide a numbers in a table of data by 1,000, all at once 1

Top