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)
Result:
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.