INT Function

Returns the integer portion of a number
Sample Usage
  • value
  • value
    The value, typically within a cell, to check

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.

Ask the Community