MROUND

Rounds number to an integer multiple of a factor.

Sample Usage

MROUND(10,3)
MROUND(A4,A5)

Syntax

MROUND(value, factor)

• value - The number to be rounded.
  
• factor - The number to whose multiples the value will be rounded.
  
  

Examples

MROUND(10,3) returns a value of 9.
MROUND(A4,A5) Rounds A4 to the nearest multiple of A5.

Notes

• 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.