Rounds a number up to the nearest specified multiple.
Syntax
CEILING(number, significance)
Arguments
number
The number to round up.
significance
The multiple to round number to.
Returns
The number that results from the rounding. If the specified number value 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, you can round prices in a Price field up to the nearest nickel with the following expression:
CEILING([Price], 0.05)
If the Price value is 20.52, CEILING( ) returns 20.55.
The following example rounds prices up to the nearest dime:
CEILING([Price], 0.1)
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.
The following example rounds prices up to the nearest dollar:
CEILING([Price], 1)
If the Price value is 20.30, CEILING( ) returns 21.0.

 Additional Links: Forums | Blogs | Support | Give Us Feedback | More...