Functions
MROUND
Round to nearest multiple
Try it
When to use it
When should I use MROUND instead of ROUND?
Use MROUND when you need to round to a specific multiple rather than a number of decimal places — for example rounding prices to the nearest 0.05 or time values to the nearest 15 minutes.
Used in
Syntax
MROUND(number, multiple)Examples
=MROUND(21,14) // => 28
=MROUND(10,3) // => 9