Exceljet

Quick, clean, and to the point

Excel INT Function

Excel INT function
Summary 

The Excel INT function returns the integer part of a decimal number by rounding down to the integer. Note the INT function rounds down, so negative numbers become more negative. For example, while INT(10.8) returns 10, INT(-10.8) returns -11.

Purpose 
Get the integer part of a decimal by rounding down
Return value 
The integer part of the number after rounding down
Syntax 
=INT (number)
Arguments 
  • number - The number from which you want an integer.
Usage notes 

The INT function returns the integer part of a decimal number, after rounding down.

Example #1 - positive numbers

When numbers are positive, the INT function always rounds down to the next lowest whole number:

=INT(3.25) // returns 3
=INT(3.99) // returns 3

Example #2 - negative numbers

When rounding negative numbers, the INT function will round down away from zero:

=INT(10.8) // returns 10
=INT(-10.8) // returns 11

INT vs TRUNC

INT is similar to the TRUNC function because they both can return the integer part of a number. However, TRUNC simply truncates a number, while INT actually rounds a number down to an integer. With positive numbers, and when TRUNC is using the default of 0 for num_digits,  both functions return the same results. With negative numbers, the results can be different. INT(-3.1) returns -4, because INT rounds down to the lower integer. TRUNC(-3.1) returns -3. If you simply want the integer part of a number, you should use TRUNC.

Rounding functions in Excel

Excel provides a number of functions for rounding:

Notes

  • Use the INT function when you want the integer part of a decimal number, and it's OK to always round down.
  • Use the TRUNC function if you only want the exact the integer part of both negative and positive numbers.