Rounds a number down to the nearest integer.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
INT(number)The INT function removes the fractional part of a number, effectively rounding it down to the nearest integer. Note that for negative numbers, it rounds away from zero to the next smaller integer.
=INT(8.9)Ergebnis: 8
Rounds 8.9 down to the nearest integer.
=INT(-8.9)Ergebnis: -9
Rounds -8.9 down to the next smaller integer.
INT rounds down to the nearest integer, while TRUNC simply removes the fractional part without rounding.