Returns a number rounded to the desired multiple.
Syntax
MROUND(number,multiple)
number |
is the value to round. |
multiple |
is the multiple to which you want to round number. |
MROUND rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple.
MROUND(10, 3) = 9
MROUND(-10, -3) = -9
MROUND(1.3, 0.2) = 1.4
____________________________
See also: