Rounding

[Maxine]

I have a column of figures that I need to round to the nearest 10,000. How
do I do it and can I do this in bulk or do I have to do one cell at a time?

 

[Rick Rothstein]

Use negative values for ROUND's second argument...

=ROUND(A2,-4)

 

[Francis]

try

=MROUND(A1,10000)
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another