Documentation/Calc Functions/INT
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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:
ODF standard:
Related (or similar) Excel functions:
INT