CEILING( )The number that results from the rounding up. If num is an exact multiple of significance, no rounding occurs.CEILING( ) is commonly used to round up prices. For example, to avoid dealing with pennies, you can round up prices in a Price data field to the nearest nickel using the following expression:If the Price value is 20.52, CEILING( ) returns 20.55.If the Price value is 20.52, CEILING( ) returns 20.60. If the Price value is 20.40, CEILING( ) returns 20.40. No rounding occurs because 20.40 is already a multiple of 0.1.If the Price value is 20.30, CEILING( ) returns 21.0.


Copyright Actuate Corporation 2012 