Excel INT Function

Excel INT Function


Get the integer part of a decimal by rounding down

Return value 

The integer part of the number after rounding down


=INT (number)


  • number – The number from which you want an integer.

Usage notes 

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.

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas