CEILING (Primitive Spread Function) rounds a number up to the nearest multiple of a specified value.
SYNTAX:
CEILING(value1,value2,...)
REMARKS:
Specify the number to round using the value1 argument. Specify the value to use as the rounding factor using the value2 argument. Use either both positive or both negative numbers for the arguments. Regardless of the sign of number, the number is rounded away from zero.
EXAMPLES:
CEILING(C4,B2)
CEILING(B3,0.05)
CEILING(4.65,2)=6
CEILING(-2.78,-1)=-3