How to round to nearest 5 in Microsoft Excel

In this tutorial we will learn how to round a number to the nearest multiple of 5 using the Mround function. The MROUND function in Excel rounds a given number to its nearest multiple, which is specified in the function’s second argument, known as the “significance”. The first argument, “number”, is the value that needs to be rounded. In summary, Mround requires two arguments, the “number” to be rounded, and the “significance” – the multiple to which the number is to be rounded.

Microsoft Excel is a spreadsheet software developed by Microsoft. It is widely used for data analysis, financial modeling, and project management. The software allows users to create and manipulate tables of data, perform calculations and functions, create charts and graphs, and perform various other tasks related to data organization and analysis.

Step 1 – Select the Cell

– Select the cell where you want to get the rounded off number

Step 2 – Click on Insert Function

– Click on Insert Function in task bar and a dropdown menu will appear

Step 3 – Use the Mround function

– In the drop down menu type “Mround” in function selecting box 

Step 4 – click on OK

– Click on “OK” and a menu will appear

Step 5 – Enter the Cell Reference

– Enter the reference of the cell where you want the result to be shown in the box right after the Number  in the Function Argument dialog box.

Step 6 – Enter the number 5

– Enter the number “5” in the box right next to Multiple in the Function Argument dialog box.

Step 7 – Click on OK

– Click on ok to get the required result

Step 8 – Apply the Function on the complete column

– To apply the function on  the complete column use the “handle select” and “drag and drop” method.