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 |
Still need help?
Use the Smartsheet Formula Template to view examples and practice working with functions in real-time.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.