Purpose
Round a number to the nearest specified multiple
Return value
A rounded number.
Syntax
=MROUND (number, multiple)
Arguments
- number – The number that should be rounded.
- multiple – The multiple to use when rounding.
Usage notes
MROUND rounds up, away from zero.
The rounding occurs when the remainder left from dividing number by multiple is greater than or equal to half the value of multiple.