In this formula tutorial, we will learn to round a number to the nearest 5, 50, and .5. You can use these formulas in Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, and Excel for Mac.
Round to Nearest .5, 5, and 50
To round to the nearest 5, you can use the MROUND function. You can specify the argument to get the multiple of in this function. Look at the following formula.
=MROUND(A2,5)
In the above formula, you have used 5 as a multiple to round the value. Now, if you look at the first value in cell A2, which is 4, the nearest multiple of 5 is 5. And for the second value, you got 15, which is the nearest multiple of 5.
In the same way, with the MROUND function, you can use 50.
And the same function goes for .5.
Round Down to the Nearest 5
To round down a number to 5, you need to use the function FLOOR. This function has the same arguments that you have in the MROUND function.
=FLOOR(D8,5)
And in the same way for the 50.
And for .5 as well.
Round-Up to the Nearest 5
You must use the CEILING function to round up a number to the nearest 5.
For 50.
And in the end, for .5.
