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

a real that 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