Normally when you round to decimal places, the item after the comma is a
positive: a "2" rounds to hundreths. But when you round on the "other side"
of the decimal, you put it in as negative. -4 will take you to 10,000 place I
believe.

ex:
=ROUND(cell_ref,-4)

"Sorianop" wrote:

On Excel I need to round up to tens of thousands...
e.g. 158000 to 160000
or 21500 to 30000...
Does any one know this formula???

Thank You in advance