CEILING( ) Function

Returns the next highest integer that is greater than or equal to the specified numeric expression.

CEILING(nExpression)

Return Value

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

Concepts

Creating Numeric Expressions

Reference

FLOOR( ) Function

ROUND( ) Function

Integer Field Type

Other Resources

Functions

Language Reference (Visual FoxPro)