Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
This article describes the formula syntax and usage of the INT function.
Description
Rounds a number down to the nearest integer.
Syntax
INT(number)
The INT function syntax has the following arguments:
- number - Required. The real number you want to round down to an integer.
Example
| Formula | Description | Result |
| =INT(8.9) | Rounds 8.9 down. | 8 |
| =INT(-8.9) | Rounds -8.9 down. Rounding a negative number down rounds it away from 0. | -9 |
| =A2-INT(A2) | Returns the decimal part of a positive real number in cell A2. | 0.5 |
Errors
For a full list of formula errors, please read Formula errors.