Excel INT Function

Basic Description

The Excel Int function truncates a supplied number down to the closest integer.

The syntax of the function is:

INT( number )

Where the number argument is any numeric value.

Note that the Int function always rounds down. If you want to round to the nearest integer (up or down), you need to use the Round Function or the Mround Function.

Int Function Examples

The following spreadsheets show the Excel Int function applied to several different supplied numbers:

1 =INT(100.9)
25.22=INT( A2 )
35.99=INT( A3 )
499.5=INT( A4 )
5-6.1=INT( A5 )
6-100.9=INT( A6 )
1 100

The above examples show how the Int function always rounds down. Even with negative numbers, the function rounds down (away from zero).

Further information on the Excel Int Function is provided on the Microsoft Office website. Also, a comparison of the Excel Rounding Functions is provided on the Excel Rounding Functions page.