Rounds a number down to the nearest integer.
פונקציה זו פועלת ב-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.