Truncates a number to an integer by removing the fractional part.
Bu işlev, Google E-Tablolar'da Excel'deki gibi çalışır — aynı söz dizimi ve bağımsız değişkenler.
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)Sonuç: 8
Truncates 8.9 to the nearest integer by removing the decimal.
=TRUNC(-2.75, 1)Sonuç: -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.