How to Use Excel INT Function (Examples + Video)

In this tutorial, you’ll learn how to use the INT function in Excel.

Excel INT Function Overview

Excel INT Function

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.

Syntax

=INT(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.

Excel INT Function - Example 1

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.

Excel INT Function - Example 2

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:

=INT(YEARFRAC(A2,TODAY()))

Excel INT Function - Example 3

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:

Related Excel Tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Picture of Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

1 thought on “How to Use Excel INT Function (Examples + Video)”

Leave a Comment

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster