Returns the specified number rounded to the specified multiple.
Syntax
 Copy Code
|
|---|
MROUND( Number number, Number multiple ) → Number |
Parameters
- number
- Required. The value to round.
- multiple
- Required. The multiple to which to round number.
Remarks
Returns the number x, for which x/multiple is integer (that is, multiple divides x), and for any other y with the same property, ABS(y-number)>=ABS(x-number). In case that two such x exist, the greater one is returned.
The number argument and the multiple argument must have the same sign; otherwise, the function returns #NUM!. If multiple is 0, the function returns zero.
See Also
Function Reference
CEILING Function
EVEN Function
FLOOR Function
ODD Function
ROUND Function
ROUNDDOWN Function