Google Sheets-funktion

TRUNC

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

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

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.

Argument

numberobligatorisktThe number you want to truncate.
num_digitsvalfrittThe number of digits to which you want to truncate; defaults to 0.

Exempel

=TRUNC(8.9)

Resultat: 8

Truncates 8.9 to the nearest integer by removing the decimal.

=TRUNC(-2.75, 1)

Resultat: -2.7

Truncates -2.75 to one decimal place.

Vanliga frågor

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.

Relaterade funktioner

ROUND ROUNDDOWN INT