INT() : extract the integer part of a number

The INT() function returns the integer part of a number by rounding it down, and returns an integer. It differs from simple rounding for negative numbers.

INT() always rounds down, including for negative numbers. The result is never the nearest rounded value: for a negative number, it is smaller than the original number. INT(-3.7) returns -4, not -3.

Syntax

INT(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 for which you want to obtain the integer less than or equal to it.

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 number

INT(3.7)

Result: 3

Negative number

INT(-3.7)

Result: -4

Go further

ROUND()

Round a number to a chosen decimal precision, instead of truncating it.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.