Excel INT Function


Basic Description

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

The syntax of the function is:

INT( number )

Where the number argument is any numerical value. This can be supplied directly to the function, or it can be provided as a reference to a cell containing a number, or a value returned from another function or formula.


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:

 Formulas:
  A B
1   =INT(100.9)
2 5.22 =INT( A2 )
3 5.99 =INT( A3 )
4 99.5 =INT( A4 )
5 -6.1 =INT( A5 )
6 -100.9 =INT( A6 )
 Results:
  A B
1   100
2 5.22 5
3 5.99 5
4 99.5 99
5 -6.1 -7
6 -100.9 -101

The above examples show how the Int function always rounds down. Even with negative numbers, the function rounds to the integer below or equal to the supplied number argument.

Further information on the Excel Int Function is provided on the Microsoft Office website.

Return to the Excel Math Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2014 ExcelFunctions.net