MROUND
Syntax:
MROUND ( x , multiple)
Description: Computes x rounded to multiple, away from zero. It rounds up if the remainder of dividing x by multiple is greater than or equal to half the value of multiple; otherwise, it rounds down.
Arguments:
Name |
Type |
Description |
|---|---|---|
x |
number |
The value to round. |
multiple |
number |
The multiple to which x is to be rounded. |
Return Type and Value: number – x rounded to multiple.
However, if x and multiple have different signs, #NUM! is returned.
example: