Rounds a number down to the nearest integer.
Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.
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)Resultaat: 8
Rounds 8.9 down to the nearest integer.
=INT(-8.9)Resultaat: -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.