Excel Math Functions : INT

Introduction to INT Function

INT function returns the integer part of a decimal number. In simple words, it rounds down the number by removing its decimals and returns only the integer part of the number.

Download Sample file

Download Sample file for working with the tutorial.

Syntax of INT Function

INT(number)

Arguments in INT Function

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

Notes

• It will round down both positive or negative numbers.

Tutorial of INT Function in MS Excel

In the below example, we have rounded 9.9 to 9 and 8.9 to 8. You can use this rounding function to remove decimals from the numbers.

In the example above, the result will be 2.

Other Math Function in Microsoft Excel

Explore other math function in Microsoft excel. The list of all the math function available for everyday use is given below –

• ABS Function
• EVEN Function
• INT Function
• MOD Function
• MROUND Function
• RAND Function
• SUM Function
• SUMIF Function
• SUMIFS Function
• SUMPRODUCT Function
• TRUNC Function