EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel INT Excel Function

INT Excel Function

By Pradeep SPradeep S

INT Function in Excel

INT in Excel

INT in Excel is a very simple function used to convert any number into an integer value. Integer values are any number that is a whole number but can be a positive or negative number. Int function can consider any number, whether it is a decimal, fraction, or square root value, but in the end, we will be getting a whole number out of it.

INT Formula in Excel:

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Below is the INT Formula in Excel.

INT Formula in Excel

where

Number or Expression – It is the number you want to round down to the nearest integer.

How to Use INT Function in Excel?

INT function in Excel is very simple and easy to use. Let us understand the working of the INT function in Excel by some INT Formula examples. INT function can be used as a worksheet function and VBA function.

You can download this INT Function Excel Template here – INT Function Excel Template

Example #1

The below-mentioned table contains a value in cell “C8”, i.e. 6.79, which is a positive number; I need to find out the nearest integer for 6.79 using the INT function in Excel.

Select the cell “E8,” where the INT function needs to be applied.

Example 1-1

Click the insert function button (fx) under the formula toolbar; a dialog box will appear, type the keyword “INT” in the search for a function box, INT function will appear in the Select a function box. Double-click on the INT function.

INT Example 1-2

A dialog box appears where arguments (number) for the INT function need to be filled or entered.

i.e. =INT(C8).

INT Example 1-3

It removes the decimal from the number and returns the integer part of the number, i.e. 6.

INT Example 1-4

Example #2

The below-mentioned table contains a value in cell “C14”, i.e. -5.89, which is a negative number; I need to find out the nearest integer for -5.89 using the INT function in Excel. Select cell E14, where the INT function needs to be applied.

Example 2-1

Click the insert function button (fx) under the formula toolbar; a dialog box will appear, type the keyword “INT” in the search for a function box, INT function will appear in the Select a function box. Double-click on the INT function.

INT Example 2-2

A dialog box appears where arguments (number) for the INT function need to be filled or entered.

i.e. =INT(C14)

INT Example 2-3

It removes the decimal from the number and returns the integer part of the number, i.e. -6.

INT Example 2-4

When the INT function is applied to a negative number, it rounds it down. i.e. It returns the number lower than the given number (More negative value).

Example #3

In the below mention example, I have the date of birth ( 16th May 1982) in cell “J8” I need to calculate the age in cell “L8” using the INT function in Excel.

Example 3-1

Before the INT function in Excel, let’s know about the YEARFRAC function; the YEARFRAC function returns a decimal value representing fractional years between two dates. I.e. Syntax is =YEARFRAC (start_date, end_date, [basis]). It returns the number of days between 2 dates as a year.

Here the INT function is integrated with the YEARFRAC function in cell “L8”.

YEARFRAC formula takes the date of birth and the current date (given by the TODAY function) and returns the output value as age in years.

i.e. =INT(YEARFRAC(J8,TODAY()))

INT Example 3-2

It returns the output value i.e. 36 years.

INT Example 3-3

Example #4

Usually, Excel stores the date value as a number, considering the date as an integer and the time as a decimal portion. If a cell contains a date and time as a combined value, you can only extract the date value using the INT function in Excel. Cell “P8” contains the date and time as a combined value. Here I need to extract the date value in cell “R8.”

Select the cell R8 where the INT function needs to be applied.

Example 4-1

Click the insert function button (fx) under the formula toolbar; a dialog box will appear, type the keyword “INT” in the search for a function box; the INT function will appear in select a function box. Double-click on the INT function.

Example 4-2

A dialog box appears where arguments (number) for the INT function need to be filled or entered.

i.e. =INT(P8)

INT Example 4-3

It removes a decimal portion from the date & time value and returns only the date portion as a number, where we need to discard the fraction value by formatting in the output value.

i.e. 11/12/18

INT Example 4-4

Example #5

The below-mentioned table contains a value less than 1 in cell “H13”, i.e. 0.70, which is a positive number; I need to find out the nearest integer for decimal value, i.e. 0.70, using the INT function in Excel. Select cell I13 where the INT function needs to be applied.

Example 5-1

Click the insert function button (fx) under the formula toolbar; a dialog box will appear, type the keyword “INT” in the search for a function box, INT function will appear in the Select a function box. Double-click on the INT function.

Example 5-2

A dialog box appears where arguments (number) for the INT function need to be filled or entered.

i.e. =INT(H13)

INT Example 5-3

Here, it removes the decimal from the number and returns the integer part of the number, i.e. 0

 INT Example 5-4

Things to Remember

  • In the INT function, Positive numbers are rounded toward 0, while negative numbers are rounded away from 0. E.G. =INT(2.5) returns 2 and =INT(-2.5) returns -3.
  • Both INT() and TRUNC() functions are similar when applied to positive numbers; both can convert a value to its integer portion.
  • If any wrong type of argument is entered in the function’s syntax, it results in #VALUE! Error.
  • If the referred cell is not a valid or invalid reference in the INT function, it will return or result in #REF! Error.
  • #NAME? Error occurs when Excel does not recognize specific text in the formula of the INT function.

Recommended Articles

This has been a guide to INT Function in Excel. Here we discuss the INT Formula in Excel and how to use the INT function in Excel, along with practical examples and downloadable Excel templates. You can also go through our other suggested articles –

  1. MID Function in Excel
  2. EVEN Excel Function
  3. POWER Function in Excel
  4. Excel Formula For Rank
MICROSOFT POWER BI Training
48+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MS Excel & VBA for Data Science
128+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
All-in-One Financial Analyst Masters Training Program
1000+ Hours of HD Videos
43 Learning Paths
250+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
All in One Data Science Bundle (360+ Courses, 50+ projects)
1500+ Hour of HD Videos
80 Learning Paths
360+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Popular Course in this category
MS Excel Course
 223+ Hours of HD Videos
35 Courses
13 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.9
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

Download INT Function Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download INT Function Excel Template

EDUCBA

डाउनलोड INT Function Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more