All functions / Math
MROUND
Rounds to the nearest multiple of a number.
Syntax
=MROUND(number, multiple)
Arguments
number: The number to use.multiple: The multiple to round to, e.g. 5 or 0.25.
Example
=MROUND(17, 5) → 15
All functions / Math
Rounds to the nearest multiple of a number.
=MROUND(number, multiple)
number: The number to use.multiple: The multiple to round to, e.g. 5 or 0.25.=MROUND(17, 5) → 15