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.
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:
Based on the Excel spreadsheet above, the following INT examples would return:
Note: The INT function returns the integer part of a decimal number, after rounding down.