How to use the Excel INT function

INT or Integer function in excel is used to return the nearest integer of a given number, this function is used when we have a large number of data sets and each data in different format let say in float then this function returns the integer part of the number, for example for INT(5.4) will give result as 5.

Syntax: =INT(number)

The INT function syntax has the following arguments:

  • Number: It is the number you want to round down to the nearest integer.

Example: Let’s look at some Excel INT function examples and explore how to use the INT function as a worksheet function in Microsoft Excel:

Syntax:  =INT(B9)


Based on the Excel spreadsheet above, the following INT examples would return:

Syntax: =INT(B10)
Result: 1367

Syntax: =INT(B11)
Result: 1555

Syntax: =INT(B12)
Result: 186

Syntax: =INT(B13)
Result: 1982

Syntax: =INT(B14)
Result: 1658

Syntax: =INT(B15)
Result: 1985

Syntax: =INT(B16)
Result: 256

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

Add a Comment

Your email address will not be published. Required fields are marked *