Round To The Nearest Thousand or Million

  • Thread starter Thread starter Robert Nguyen
  • Start date Start date
R

Robert Nguyen

I'm working with large numbers. How can I make the result
round up or down to the nearest thousand or even million?
Any suggestion will be greatly appreciated.
 
Robert Nguyen said:
I'm working with large numbers. How can I make the result
round up or down to the nearest thousand or even million?
Any suggestion will be greatly appreciated.
Click to expand...

=ROUND(A1,-3)
or
=ROUND(YourFormula,-3)
to round to thousand.

=ROUND(A1,-6)
or
=ROUND(YourFormula,-6)
to round to million.
 
I'm testing out the Ceiling and Floor formulas and it's
working, but yours is much simpler. Thank you so much.
 
Back
Top