Reference > Functions reference > Number functions > Floor

Floor

Returns a number rounded down to the next lower integer.

Format

Floor(number)

Parameters

number - any numeric expression or field containing a numeric expression

Data type returned

number

Originated in

FileMaker Pro 7.0

Example 1

Floor(1.25) returns 1.

Floor(-1.25) returns -2.

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.