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 |