Rounding to billions, millions, etc.

P

Poppi

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

JMB

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 a number up to a certain ending digit 6
Formula help - rounding up and round down? 2
Rounding value from millions to decimal places 6
Help with Nested IF Then statement? 3
Need help in rounding answers to nearest multiple 6
Dumb question alert! What program to use? 0
Rounding data entered as Millions, how to please 3
New computer, how do i move outlook 365 ENTIRELY? 0

Top