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 DataFormulaDescriptionResult
1.4=INT(1.4)Returns integer portion of 1.41
-1.9=INT(-1.9)Returns integer portion of -1.9-1
0.5=INT(0.5)Returns integer portion of 0.50
Referenced cell Integer1 that contains the value 425.99=INT(Integer1)Returns integer portion of 425.99425

 

Was this article helpful?
YesNo