이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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)결과: 8
Rounds 8.9 down to the nearest integer.
=INT(-8.9)결과: -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.