CEILING( )The number that results from the rounding. If the specified number value 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 prices in a Price field up to the nearest nickel with 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.50, CEILING( ) returns 20.50. No rounding occurs because 20.50 is already a multiple of 0.1.If the Price value is 20.30, CEILING( ) returns 21.0.


Copyright Actuate Corporation 2012 