Truncates a number to an integer by removing the fractional part.
Sintaxis
TRUNC(number, [num_digits])Argumentos
numberobligatorio
The number you want to truncate.
num_digitsopcional
The number of digits to which you want to truncate; defaults to 0.
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)→8Truncates 8.9 to the nearest integer by removing the decimal.
=TRUNC(-2.75, 1)→-2.7Truncates -2.75 to one decimal place.
Select the cell
Click on the cell where you want the result to appear.
Enter the formula
Type =TRUNC(number, [num_digits]) and replace the arguments with your desired values.
TRUNC removes the fractional part, while INT rounds numbers down to the nearest integer based on the value of the fractional part.