Funzione di Google Sheets

TRUNC

Truncates a number to an integer by removing the fractional part.

Genera una formula con l'IA La stessa funzione in Excel

Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.

Sintassi

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.

Argomenti

numberobbligatorioThe number you want to truncate.
num_digitsfacoltativoThe number of digits to which you want to truncate; defaults to 0.

Esempi

=TRUNC(8.9)

Risultato: 8

Truncates 8.9 to the nearest integer by removing the decimal.

=TRUNC(-2.75, 1)

Risultato: -2.7

Truncates -2.75 to one decimal place.

Domande frequenti

What is the difference between TRUNC and INT?

TRUNC removes the fractional part, while INT rounds numbers down to the nearest integer based on the value of the fractional part.

Funzioni correlate

ROUND ROUNDDOWN INT