The MROUND function returns a number rounded to the indicated significant multiple.
Syntax
MROUND(
number,
multiple
)
Parameters
- number: Number to round.
- multiple: Significant multiple to which you want to round number.
Returned value
The MROUND function returns a number.
Additional Information
The MROUND function rounds number to the nearest multiple of multiple. This means that MROUND(17, 5) returns 15 (since 20, even though it is also a multiple of 5, is more distant from the number 17 than 15).
Examples
In this example, different whole numbers are rounded to several significant multiples:
In this second example several real numbers are rounded:
Category
Mathematical and trigonometric
