Returns a number rounded to the desired multiple.
|number||The number to round.|
|multiple||The multiple of significance to which you want to round the number.|
A decimal number.
MROUND rounds up, away from zero, if the remainder of dividing number by the specified multiple is greater than or equal to half the value of multiple.
Example: Decimal Places
The following expression rounds 1.3 to the nearest multiple of .2. The expected result is 1.4.
Example: Negative Numbers
The following expression rounds -10 to the nearest multiple of -3. The expected result is -9.
The following expression returns an error, because the numbers have different signs.