# Documentation/Calc Functions/MROUND

Other languages:
English • ‎Nederlands • ‎dansk • ‎español

MROUND

Mathematical

## Summary:

Rounds one real number to the nearest integer multiple of a second real number.

## Syntax:

MROUND(Number; Multiple)

## Returns:

Returns a real number that is the rounded value.

## Arguments:

Number is a real number, or a reference to a cell containing that number, that is the value to be rounded.

Multiple is a real number, or a reference to a cell containing that number, that is the multiple to be used in the rounding. The sign of the Multiple argument is not significant.

• If either Number or Multiple is non-numeric, then MROUND reports a #VALUE! error.
• If Multiple is equal to 0, then MROUND returns the value 0.

• For real x and y (y <>0), MROUND implements the following formula:

$\displaystyle{ \text {MROUND}(x, y)~=~y\times \text{ROUND}\left(\frac{x}{y}\right) }$

## Examples:

Formula Description Returns
=MROUND(15.5; 3) Here the function rounds 15.5 to the nearest multiple of 3. 15
=MROUND(D1; D2) where cells D1 and D2 contain the numbers 1.4 and 0.5 respectively. Here the function rounds 1.4 to the nearest multiple of 0.5. 1.5
=MROUND(11; 2) Here the function rounds 11 to the nearest multiple of 2. Note that "halfway" cases are rounded away from zero. The formula =MROUND(11; -2) gives the same result because the negative sign of the Multiple argument is not significant. 12
=MROUND(-11; 2) Here the function rounds -11 to the nearest multiple of 2. Note that "halfway" cases are rounded away from zero. The formula =MROUND(-11; -2) gives the same result because the negative sign of the Multiple argument is not significant. -12

MROUND