Excel INT Function

HomeExcel Functions List (Top 100) Examples + Sample FileExcel INT Function (Example + Sample File)

What is EXCEL INT FUNCTION

The Excel INT Function is listed under Microsoft Excel's Maths Functions category. It 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.

How to use it

To learn how to use the INT function in Excel, you need to understand its syntax and arguments:

Syntax

INT(number)

Arguments

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

Notes

  • It will round down both positive or negative numbers.

Example

To master the INT function we need to try it out in an example and below is one which you can try out:

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.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.