Rounding to billions, millions, etc.
I am creating rounding worksheets for elementary age students - nearest
billion, hundred million, ten million, million, etc. I would like to create an answer sheet for teachers to use. How can I do this in excel? Thank you. |
Rounding to billions, millions, etc.
to round to the nearest million
=MROUND(A1,1000000) which is part of the Analysis toolpak. check Tools/Add-Ins and make sure this add-in is checked. "Poppi" wrote: I am creating rounding worksheets for elementary age students - nearest billion, hundred million, ten million, million, etc. I would like to create an answer sheet for teachers to use. How can I do this in excel? Thank you. |
Rounding to billions, millions, etc.
And =ROUND(A1,-6) doesn't need the Analysis ToolPak.
-- David Biddulph "JMB" wrote in message ... to round to the nearest million =MROUND(A1,1000000) which is part of the Analysis toolpak. check Tools/Add-Ins and make sure this add-in is checked. "Poppi" wrote: I am creating rounding worksheets for elementary age students - nearest billion, hundred million, ten million, million, etc. I would like to create an answer sheet for teachers to use. How can I do this in excel? Thank you. |
All times are GMT +1. The time now is 05:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com