Rounds a number down to the nearest integer.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
INT(number)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)Kết quả: 8
Rounds 8.9 down to the nearest integer.
=INT(-8.9)Kết quả: -9
Rounds -8.9 down to the next smaller integer.
INT rounds down to the nearest integer, while TRUNC simply removes the fractional part without rounding.