What is INT (Integer) Function in Excel?
The INT Excel function rounds a decimal number down to the nearest integer and returns it. It is one of the rounding functions in Excel which returns a positive or negative integer as an output. However, it returns the nearest lower integer in the case of positive numbers, and the negative numbers become more negative.
For example, below, we have two numbers. Let us apply the INT formula to them and check the output. Enter the formula =INT(A2) in cell B2. Press Enter and copy the formula to B3 as well. The INT function returns the integer 3 for the number 3.6. When we use the function on -3.6, it returns an integer away from zero, that is, -4.
Frequently Asked Questions (FAQs)
The INT Excel function returns the integer part of a decimal number. It also returns the nearest integer, lower than the number supplied. In the case of negative numbers, it returns the nearest integer away from zero. For instance, =INT(-3.5) gives an output of -4.
When any number is entered in an Excel cell, it is in the General format. However, if you convert it into the nearest integer using the INT Excel function, you can format it according to requirements, such as a number, date, etc., by right-clicking and choosing the Format Cells option. Then, select the Number tab in the pop-up window and format the INT function.
If you have a decimal number, you can round it up to the nearest integer with several rounding functions available in Excel. Also, you can use the INT or TRUNC function to round a number to the nearest integer. The other rounding functions include ROUND, ODD, EVEN, and so on.
Download Template
📥Download the ready-to-use Excel template to practice this tutorial yourself.
Download Excel TemplateRecommended Articles
A guide to INT Excel Function and its definition. Here we learn how to use INTEGER formula along with examples and downloadable excel template. You can learn more from the following articles –