CEILING( ) Function
Returns the next highest integer that is greater than or equal to the specified numeric expression.
CEILING(nExpression)
Return Values
Numeric
Parameters
- nExpression
Specifies the number whose next highest integer CEILING( ) returns.
Remarks
CEILING rounds a number with a fractional portion to the next highest integer.
Example
STORE 10.1 TO num1
STORE -10.9 TO num2
? CEILING(num1) && Displays 11
? CEILING(num2) && Displays -10
? CEILING(10.0) && Displays 10
? CEILING(-10.0) && Displays -10
See Also
FLOOR( ) | ROUND( ) | Creating Numeric Expressions | Integer Field Type