Excel INT Function Overview

When to use Excel INT Function

INT Function is used when you want to get the integer portion of a number.

What it Returns

It returns an integer number.



Input Arguments

number – the number for which you want to get the integer value.

Excel INT Function Examples

Below are three examples of using the INT function in Excel.

Example 1 – Getting the Integer Part from a Positive number

When you use INT function with a positive integer, it discards the decimal part and gives you the integer part of the number.

For example, in the above example, it returns 4 as the function rounds down the value in cell A2.

Example 2 – Getting the Integer Part from a Negative number

When you use the INT function with a negative number, it rounds down the number. This means that you get the number which is lower that the given number.

In the above example, the result is -5, which is lower than -4.89. So instead of giving you the integer part (as it did in Example 1), it gives you the number which is an integer and lower than the given number.

Example 3 – Getting the Age using Date of Birth

You can use the INT function to get the age of a person using their date of birth. To do this, you need to use it along with TODAY and YEARFRAC functions. Suppose the date of birth is 14 May 1988, then you can use the below formula to calculate the age in Excel:

YEARFRAC formula takes the date of birth and the current date (which is given by the TODAY function) and returns the age in years. It has the integer as well as the fraction part. Then the INT function returns only the integer part from it.

Video Tutorial

Related Excel Functions:

Excel MOD Function. Excel RAND Function. Excel RANDBETWEEN Function. Excel ROUND Function. Excel RANK Function. Excel LARGE Function. Excel MAX Function. Excel MIN Function. Excel SMALL Function.

Related Excel Tutorials:

How to Remove Time from Date in Excel