ExcelBanter - How do you round off numbers 5,518,943 to 5,520,000

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do you round off numbers 5,518,943 to 5,520,000 (https://www.excelbanter.com/excel-discussion-misc-queries/105277-how-do-you-round-off-numbers-5-518-943-5-520-000-a.html)

laurn

How do you round off numbers 5,518,943 to 5,520,000

FxM

How do you round off numbers 5,518,943 to 5,520,000

laurn a écrit :
---- nothing ----

Have a look at round(...,-4)

HTH
FxM

All times are GMT +1. The time now is 03:00 AM.