Rounds one number to the nearest integer multiple of another.
Sample Usage
MROUND(21,14)
MROUND(A2,3)
Syntax
MROUND(value,factor)
-
value
- The number to round to the nearest integer multiple of another. -
factor
- The number to whose multiplesvalue
will be rounded.
Notes
-
Both
value
andfactor
may be non-integral. -
value
andfactor
must have the same sign; that is, they must both be positive or both negative. If either is zero,MROUND
will return0
. -
If
value
is equally close to two multiples offactor
, the multiple with the greater absolute value will be returned.
See Also
TRUNC
: Truncates a number to a certain number of significant digits by omitting less significant digits.
ROUNDUP
: Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.
ROUNDDOWN
: The ROUNDDOWN function rounds a number to a certain number of decimal places, always rounding down to the next valid increment.
ROUND
: The ROUND function rounds a number to a certain number of decimal places according to standard rules.
INT
: Rounds a number down to the nearest integer that is less than or equal to it.
FLOOR
: The FLOOR function rounds a number down to the nearest integer multiple of specified significance.
CEILING
: The CEILING function rounds a number up to the nearest integer multiple of specified significance.