MROUND function
The MROUND function is one of the math and trigonometry functions. It is used to round the number to the desired multiple.
Syntax
MROUND(number, multiple)
The MROUND function has the following arguments:
| Argument | Description |
|---|---|
| number | A number you wish to round. |
| multiple | A multiple you wish to round to. |
Notes
If the values of number and multiple have different signs, the function returns the #NUM! error.
How to apply the MROUND function.
Examples
The figure below displays the result returned by the MROUND function.
