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 functions

Defining calculation fields

Using operators in formulas

Was this topic helpful? Send feedback.