MROUND(number, multiple)
- Where 'number' is the number to round and
- 'multiple' is the multiple value to which number is to be rounded.
MROUND() rounds a number to specified multiple.
Description
MROUND(number, multiple)
This function is used to round a number to desired multiple.
For Example,
MROUND(3.6, 2) returns 4 as a result.
MROUND(44.1, 4) returns 44 as a result.
- The number is rounded up or down, depending on the remainder of division of the number and the multiple. If the remainder is more than or equal to half the multiple value, the number is rounded up, else it is rounded down towards zero.
- If 'num_of_digits' is omitted, Calci assumes it to be zero and rounds the number to the nearest integer.
- The number is rounded to the specified number of decimal places, if num_of_digits > 0.
- The number is rounded to the nearest integer, if num_of_digits = 0.
- The number is rounded to the left of the decimal point, if num_of_digits < 0.
- If any argument is non-numeric, Calci displays #NaN error message.
MROUND() can also be used for multiple number array as -
MROUND(2.5..6..0.5) that rounds the numbers 2.5 to 6 in steps of 0.5.
| Number | MROUND |
|---|---|
| 2.5 | 3 |
| 3 | 3 |
| 3.5 | 4 |
| 4 | 4 |
| 4.5 | 5 |
| 5 | 5 |
| 5.5 | 6 |
| 6 | 6 |
- ROUNDUP() can be used to round a number away from zero.
- ROUNDDOWN() can be used to round a number towards zero.
- MROUND() can be used to round a number to desired multiple.