INT Function

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