CEILING( ) Rounds a number up to the nearest specified multiple. Syntax CEILING(num, significance) Arguments num The numeric value to round up. significance The multiple up to which to round num. Returns The number that results from the rounding. If num is an exact multiple of significance, no rounding occurs. Examples CEILING( ) is commonly used to round up prices. For example, to avoid dealing with pennies, if the Price value is 20.52, CEILING( ) returns 20.55. You can round prices in a Price data field up to the nearest nickel with the following expression: CEILING([Price], 0.05) 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. The following example rounds prices up to the nearest dime: CEILING([Price], 0.1) The following example rounds prices up to the nearest dollar. If the Price value is 20.30, CEILING( ) returns 21.0. CEILING([Price], 1)

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy