Truncates a number to an integer by removing the fractional part.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-Excel — אותה תחביר ואותם ארגומנטים.
TRUNC(number, [num_digits])The TRUNC function removes the fractional part of a number, effectively rounding it toward zero. Unlike the ROUND function, it does not round up or down based on the value of the digits; it simply discards them.
=TRUNC(8.9)תוצאה: 8
Truncates 8.9 to the nearest integer by removing the decimal.
=TRUNC(-2.75, 1)תוצאה: -2.7
Truncates -2.75 to one decimal place.
TRUNC removes the fractional part, while INT rounds numbers down to the nearest integer based on the value of the fractional part.