Rounding to billions, millions, etc.

G

Guest

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding value in place 2
Rounding value from millions to decimal places 6
Rounding 5
Round To The Nearest Thousand or Million 3
500m, 500b, 500t, function? 4
AP makes one million minutes of historical footage available on YouTube 2
Alternate Rounding Up & Down of .50 in a column 5
Incorporating Numbers into a text string 2

Top