Explanation
In the example, cell C6 contains this formula:
=MROUND(B6,5)
The value in B6 is 17 and the result is 15 since 15 is the nearest multiple of 5 to 17.
Other multiples
As you'd expect, you can use MROUND to round to other multiples as well:
=MROUND(number,10) // nearest multiple of 10
=MROUND(number,50) // nearest multiple of 50
=MROUND(number,.05) // nearest 5 cents
And so on.
Force up or down
You can use the CEILING function to force rounding up to the nearest multiple and the FLOOR function to force rounding down to the nearest multiple.
Related formulas
Round to nearest 1000
Related functions
MROUND Function
The Excel MROUND function returns a number rounded to a given multiple. MROUND will round a number up or down, depending on the nearest multiple.
CEILING Function
The Excel CEILING function rounds a given number up to the nearest specified multiple. CEILING works like the MROUND function, but CEILING always rounds up.
FLOOR Function
The Excel FLOOR function rounds a given number down to the nearest specified multiple. FLOOR works like the MROUND function, but FLOOR always rounds down.
