Description
MRound returns a number that has been
rounded to the multiple that you specify.
Arguments
x is a value to be rounded.
multiple is a multiple that you want
to round the x value to.
Action
This function rounds up (away from zero)
if the remainder of the division is greater than or equal to half of the value
of the multiple.
Examples
MRound(10,3)
Returns 9.
MRound(-10,-3)
Returns -9.
MRound(1.3,0.2)
Returns 1.4.
MRound(5,-2)
Returns 6.
MRound(-5,2)
Returns -6.
Comments
Crystal Reports ignores the
sign of the multiple, and the result of the function takes the sign of the
first parameter.