MROUND

  • Updated

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.