| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I how do separate the millions? | Setting up and Configuration of Excel | |||
| Rounding to millions | Excel Discussion (Misc queries) | |||
| euro millions | New Users to Excel | |||
| Rounding data entered as Millions, how to please | Excel Worksheet Functions | |||
| Rounding a formula result to read thousands from millions. | Excel Worksheet Functions | |||
Linear Mode
