Description
Ceiling 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).
Examples
Ceiling(3.5,1)
Returns 4.
Ceiling(-2.5,-2)
Returns -4.
Ceiling(-2.5,2)
Returns -4.
Ceiling(5.43,.05)
Returns 5.45.
Ceiling(.43,-1)
Returns 1.
Comments
Crystal Reports ignores the
sign of the multiple, and the result of the function takes the sign of the
first parameter.
Values are always rounded up when
they are adjusted away from zero (without regard to the sign of the value). If
number is an exact multiple of multiple, no rounding occurs.