What is the formula to Round an average to the nearest 100

A

Ashish Mathur

Hi,

You may try this

=MROUND(E9,100)

In Excel 2003 and prior versions, you will need to install the Analysis
Toolpak for the MROUND() to work

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

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

Top