Reference > Functions reference > Number functions > Ceiling
 

Ceiling

Returns a number rounded up to the next integer.

Format 

Ceiling ( number )

Parameters 

number - any numeric expression or field containing a numeric expression

Data type returned 

number

Originated in 

FileMaker Pro 7.0

Example 1 

Ceiling(1.25) returns 2.

Ceiling(-1.25) returns -1.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas