Round To The Nearest Thousand or Million

[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.

 

[Paul]

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.

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

=ROUND(A1,-6)
or
=ROUND(YourFormula,-6)
to round to million.

 

[Robert Nguyen]

I'm testing out the Ceiling and Floor formulas and it's
working, but yours is much simpler. Thank you so much.

 

[Alan Cocks]

Robert

Try


=ROUNDUP(A2,-6)
or
=ROUNDDOWN(A2,-6)

Alan