How to Round Up to the Nearest 10 in Excel

Updated March 23, 2017

Microsoft Excel is one of the most commonly used tools in the data analyst community. The spreadsheet software allows users to organise large amounts of data, perform complex calculations and automate steps that may take hours into seconds. There are also many commands already programmed into the software such as the formatting or rounding formula. A formula is Excel's way of telling a cell to perform a certain function.

Open your spreadsheet and click on a cell next to the cell(s) you would like to round up to the nearest 10.

Input the formula "=MROUND(Cell Reference Number,10)". The Cell Reference Number is the number to round to and 10 is the multiple it will round to.

Familiarise yourself with the concept of different formulas using MROUND to make your task easier. The following provide examples of the output for putting the following formulas in a cell.

\=MROUND(7, 10) Rounds 7 to a nearest multiple of 10 (10) \=MROUND(-9, -10) Rounds -9 to a nearest multiple of -10 (-10) \=MROUND(18.5, 10) Rounds 18.5 to a nearest multiple of 10 (20)

Download this function if it is not available on your toolbar. On the Tools menu, click "Add-ins." Select the "Analysis TookPak" box and click "OK."

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Working as a full-time freelance writer/editor for the past two years, Bradley James Bryant has over 1500 publications on eHow, and other sites. She has worked for JPMorganChase, SunTrust Investment Bank, Intel Corporation and Harvard University. Bryant has a Master of Business Administration with a concentration in finance from Florida A&M University.