The INT function removes the fractional part of a number, effectively rounding it down to the nearest integer. Note that for negative numbers, it rounds away from zero to the next smaller integer.
=INT(8.9)→8Rounds 8.9 down to the nearest integer.
=INT(-8.9)→-9Rounds -8.9 down to the next smaller integer.
Select the cell
Click on the cell where you want to display the result.
Enter the formula
Type =INT(number) and replace 'number' with your value or cell reference.
Press Enter
Press Enter to calculate the integer value.
INT rounds down to the nearest integer, while TRUNC simply removes the fractional part without rounding.