Returns the integer portion of a number.
Sample Usage
INT(425.99)
Syntax
INT(
- value
- value—The value, typically within a cell, to check.
Examples
Here are some examples for reference.
| Example Data | Formula | Description | Result |
|---|---|---|---|
| 1.4 | =INT(1.4) | Returns integer portion of 1.4 | 1 |
| -1.9 | =INT(-1.9) | Returns integer portion of -1.9 | -1 |
| 0.5 | =INT(0.5) | Returns integer portion of 0.5 | 0 |
| Referenced cell Integer1 that contains the value 425.99 | =INT(Integer1) | Returns integer portion of 425.99 | 425 |