CEIL Function

Returns the smallest integer that is greater than or equal to the argument.

Category: Mathematical
Returned data type: Real

Syntax

CEIL(argument)

Required Argument

argument

specifies a value that has a real data type; this can be specified as a numeric constant, field name, or expression.

Details

This is also called rounding up (ceiling).

Example

x = ceil(3.5)
// outputs 4
 
x = ceil(-3.5)
// outputs -3
 
x = ceil(-3)
// outputs -3
 
x = ceil(-3*1.5)
// outputs -4