rounding #'s

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

Guest

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.
 
?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.
 
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 up to the nearest 1000 1
Rounding 3
Rounding down to .00 .25 .50 .75 1
how to divide a numbers in a table of data by 1,000, all at once 1
Excel Time Rounding in Excel 2
round up function 3
Rounding help 1

Back
Top