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.