
Use MROUND to round a value to the nearest multiple of n.
When the NEAREST direction argument is used, if the fractional part of x is .5 or greater:
- a positive value is rounded up,
- a negative value is rounded down.
Syntax
MROUND(x[, n][, d])
The MROUND function has the following arguments:
Argument | Data type | Description |
x: number | Numeric line item, property, or expression | The number that you want to round to the nearest multiple of n. |
n: number | Numeric line item, property, or expression | The multiple you want to round x to. If omitted, x will be rounded to an integer. |
d: direction | Keyword |
This keyword determines which rounding direction the function uses. If omitted, the function uses the NEAREST rounding direction. The available keywords are:
|
Returns |
Numeric line item, property or expression |
Excel equivalent
Examples
Formula | Description | Result |
MROUND(1234.56) | Only the value to be rounded, 1234.56, has been provided. The formula uses the default arguments of 0 decimal places and the NEAREST direction. | 1,235 |
MROUND(1234.56, 10) | Rounds 1234.56 to the nearest multiple of 10. The formula contains no rounding direction, so the default NEAREST direction is used. | 1,230 |
MROUND(1234.56, 10, AWAYFROMZERO) | Rounds 1234.56 to the nearest multiple of 10. The formula uses the AWAYFROMZERO rounding direction, so 1234.56, a positive number, was rounded towards positive infinity. | 1,240 |
MROUND(1234.56, 1000) | Rounds 1234.56 to the nearest multiple of 1,000. The formula contains no rounding direction, so the default NEAREST direction is used. | 1,000 |
MROUND(-1234.56, 1000, UP) | Rounds 1234.56 to the nearest multiple of 1,000. The formula uses the UP rounding direction, so x was rounded towards positive infinity. | -1,000 |
MROUND(15555, 10, NEAREST) | Rounds 15555 to the nearest multiple of 10. The formula contains no rounding direction, so the default NEAREST direction is used. As 55 is a positive number halfway between 50 and 60, x rounds up, towards positive infinity. | 15,560 |
MROUND(-15555, 10, NEAREST) | Rounds -15555 to the nearest multiple of 10. The formula contains no rounding direction, so the default NEAREST direction is used. As -55 is a negative number halfway between -50 and -60, x rounds down, towards negative infinity. | -15,560 |