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