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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - What is the formula to Round an average to the nearest 100 (https://www.excelbanter.com/excel-worksheet-functions/262481-what-formula-round-average-nearest-100-a.html)

Kirsta1988

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

T. Valko

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

=ROUND(your_formula,-2)

--
Biff
Microsoft Excel MVP

Ashish Mathur[_2_]

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

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

"T. Valko" wrote in message
...
=ROUND(your_formula,-2)

--
Biff
Microsoft Excel MVP

All times are GMT +1. The time now is 10:32 PM.