How to Round Up to the Nearest 10 in Excel
Microsoft Excel is one of the most commonly used tools in the data analyst community. The spreadsheet software allows users to organize 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.
1. Open your spreadsheet and click on a cell next to the cell(s) you would like to round up to the nearest 10.
2. 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.
3. Familiarize 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)
A B C D
1 S.No. Amount Formula Result
2 1 11.12 =MEOUND(B2,10) 10
3 2 15.2 Copy Formula 20
4 3 14 Copy Formula 10
5 4 16 Copy Formula 20
6 5 31 Copy Formula 30
7 6 2552 Copy Formula 2550
Note:- 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."