Función de Google Sheets

TRUNC

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

Generar una fórmula con IA La misma función en Excel

Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.

Sintaxis

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.

Argumentos

numberobligatorioThe number you want to truncate.
num_digitsopcionalThe number of digits to which you want to truncate; defaults to 0.

Ejemplos

=TRUNC(8.9)

Resultado: 8

Truncates 8.9 to the nearest integer by removing the decimal.

=TRUNC(-2.75, 1)

Resultado: -2.7

Truncates -2.75 to one decimal place.

Preguntas frecuentes

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.

Funciones relacionadas

ROUND ROUNDDOWN INT