FLOOR() : round a number down

The FLOOR() function rounds a number down, returning the nearest integer less than or equal to it, and returns an integer.

FLOOR() always rounds down, including for negative numbers. FLOOR(-2.1) returns -3, not -2.

Syntax

FLOOR(value)

Calling function parameters in TimeTonic:

$field_name = field (link, linked table column, number, selection, formula, text...).
"free text" = free text to be added between quotation marks.
Do not use quotation marks for numbers.

Parameters

# Parameter Description

1 value Number to round down.

Comparing INT, FLOOR and ROUND

These three functions round differently. Here is how to tell them apart.

Function	Behavior	Example
INT()	Returns the integer part of a number by rounding it down.	INT(-3.7) → -4
FLOOR()	Rounds down to the nearest integer less than or equal to the value.	FLOOR(7.5) → 7
ROUND()	Rounds a numeric value to the desired number of decimal places.	ROUND(3.14159, 2) → 3.14

The output format (integer or decimal) can be configured in the output field options of the formula editor. See Output format options in the Formula column article.

Examples

Positive decimal number

FLOOR(4.3)

Result: 4

Value close to the next integer

FLOOR(7.5)

Result: 7

Negative number

FLOOR(-2.1)

Result: -3

Go further

CEILING()

The reverse operation: round a number up to the nearest integer.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.