Jump to content

Documentation/Calc Functions/MROUND

From The Document Foundation Wiki


Function name:

MROUND

Category:

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.

Additional details:

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

[math]\displaystyle{ \text {MROUND}(x, y)~=~y\times \text{ROUND}\left(\frac{x}{y}\right) }[/math]

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

Related LibreOffice functions:

ROUND

ODF standard:

Section 6.17.4, part 2

Related (or similar) Excel functions:

MROUND