MROUND
Description
Returns the rounded value of the number to the multiple that you specify. If the
remainder of dividing the number by the multiple is greater than or equal to half of
the multiple, MROUND rounds away from 0 (up if positive; down if negative).
Syntax
MROUND(
value
,
multiple
)
- value: The number to round.
- multiple: The multiple to round the number to.
Example
Formula | Result |
|---|---|
=MROUND(12.34,1) | 12 |
=MROUND(12.34,10) | 10 |
=MROUND(12.34,2) | 12 |
=MROUND(-12.34,-2) | -12 |
=MROUND(-12.34,-1) | -12 |
Notes
- valueandmultiplearguments must have the same sign.