ExcelBanter - Rounding

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Rounding (https://www.excelbanter.com/excel-worksheet-functions/238069-rounding.html)

Maxine

Rounding

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

Rounding

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

=ROUND(A2,-4)

--
Rick (MVP - Excel)

"Maxine" wrote in message
...
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?

francis

Rounding

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

"Maxine" wrote:

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?

All times are GMT +1. The time now is 05:06 AM.