The INT function returns the integer part of a decimal by rounding down.

Syntax

=INT(number)

  • Use the INT function when you want only the integer part of a decimal number, and it’s ok to always round the number down. For example, INT (3.99) returns the number 3.
  • It’s important to note that INT actually rounds down numbers to the next lowest integer value.
  • So, while INT (10.8) = 10, INT(-10.8) = -11.
  • Use the TRUNC function if you want the exact integer part of both negative and positive numbers.

Examples

  A B C
1 Formula Results Notes
2 INT(3.97) 3  
3 INT(10.8) 10  
4 INT(-11.8) -12 INT rounds down to the next lowest integer – in this example, -11.8 rounds down to -12