Rounds number to an integer multiple of a factor.
- value - The number to be rounded.
- factor - The number to whose multiples the value will be rounded.
MROUND(10,3) returns a value of 9.
MROUND(A4,A5) Rounds A4 to the nearest multiple of A5.
- 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.
- The value and factor arguments must have the same sign. If not, a #NUM error is returned.