Jump to content

Documentation/Calc Functions/INT

From The Document Foundation Wiki


Function name:

INT

Category:

Mathematical

Summary:

Rounds a number down to the nearest integer by determining the largest integer that is less than or equal to that number.

Syntax:

INT(Number)

Returns:

Returns an integer that is the mathematical floor value of the specified number.

Arguments:

Number is a real number, or a reference to the cell containing that number, that is the number to be rounded down to the nearest integer.

  • If Number is non-numeric, then INT reports a #VALUE! error.

Additional details:

None.

Examples:

Formula Description Returns
=INT(5.7) Rounds down 5.7 to the nearest integer. 5
=INT(D1) where cell D1 contains the number -1.3. Rounds down -1.3 to the nearest integer. −2

Related LibreOffice functions:

FLOOR

FLOOR.MATH

FLOOR.PRECISE

FLOOR.XCL

ROUND

TRUNC

ODF standard:

Section 6.17.2, part 2

Related (or similar) Excel functions:

INT