MROUND function
Summary
Returns a number rounded to the desired multiple
Syntax
MROUND(number, multiple)
The MROUND function syntax has the following arguments:
• Number Required. The value to round.
• Multiple Required. The multiple to which you want to round number.
• Number Required. The value to round.
• Multiple Required. The multiple to which you want to round number.
Example
=MROUND(10, 3)
=MROUND(-10, -3)
=MROUND(1.3, 0.2)
=MROUND(5, -2)
=MROUND(-10, -3)
=MROUND(1.3, 0.2)
=MROUND(5, -2)