WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » INT Excel Function (Integer)

INT Excel Function (Integer)

INT or Integer function in excel is used to return the nearest integer of a given number, this function is used when we have a large number of data sets and each data in different format let say in float then this function returns the integer part of the number, for example for INT(5.4) will give result as 5.

INT Function in Excel

The Microsoft Excel INT Function is a function that is responsible for returning the integer portion of a number. It works by the process of rounding down a decimal number to the integer. It is a built-in Excel function and is categorized as a Math & Trig Function in Excel. It is used either as a worksheet function or a VBA function. It can be entered as a part of the INT formula, a cell of a worksheet. Here, negative numbers become more negative because the function rounds down. For example, INT (10.6) returns 10 and INT (-10.6) returns -11.

Formula

Formula of INT Function

Parameters

It accepts the following parameters and arguments:

number – The number to be entered from which you want an integer.

Return Value

The return value will be a numeric integer.

Usage Notes

  • It can be used when you want only the integer part of a number, which is in its decimal form, with rounding the number down. For example, INT (3.89) returns the value 3.
  • Integer function always rounds down the number entered in the formula to the next lowest integer value.
  • You can also use the TRUNC function in excel to get the integer part of both negative and positive numbers.

How to Open the Integer Function in Excel?

1. You can simply enter the desired Integer excel formula in the required cell to attain a return value on the argument.

2. You can manually open the INT formula dialogue box in the spreadsheet and enter the logical values to attain a return value.

3. Consider the screenshot below to see the INT Function in excel option under the Math & Trig Function menu.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

INT Function in Excel

4. Click on the INT function option. The INT formula in the excel dialogue box will open where you can put the argument values to obtain a return value.

INT Function in Excel 2

All Rounding Functions in Excel (Including INT)

There are a total of fifteen rounding functions in Excel. Consider the three tables below which specify each function and their behavior.

Please note that in the below-given tables, “more” is depicted by “+” and less is depicted by “-”.

Functions Used to Round a Number to an Integer Value

INT Function table no.1

Functions Used to Round a Number to a Specified Number of Decimal Places

INT Function table no.2

Functions Used to Round a Number to a Supplied Multiple of Significance(MS)

INT Function table no.3

How to Use INT in Excel?

Excel INT function is very simple and easy to use. Let’s look below at some of the examples of INT Function in Excel. These examples will help you in exploring the use of the INT function in Excel.

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

INT Function in Excel Example

Based on the above INT in Excel spreadsheet, let’s consider these examples and see the SUBTOTAL function return based on the syntax of the INT formula in excel.

INT Function in Excel Example 0

Consider the below screenshots of the above Integer function in excel examples for clear understanding.

Example #1

Apply the INT formula =INT(A1) to get 214

Example 1

Example #2

Here we apply the INT formula in Excel =INT(A2) to get 3

Example -2

Example #3

Now apply the INT Excel Function here =INT(A3) to get -4

Example 3

Example #4

Using the formula =INT(-3.6) to get -4

Example 4

Applications

Here are a few examples where it is generally used.

  • Extracting dates from a date and time table
  • Cash denomination calculator
  • Getting age from birthday
  • Rounding a number to ‘n’ significant digits
  • Getting days, hours, and minutes between dates
  • Calculating years between dates
  • Getting the integer part of a number

INT Excel Function Errors

If you get any kind of error from the INT Excel Function, then it can be any one of the following –

  • #NAME? – This error occurs when Excel does not recognize the text in the formula. You may have entered a wrong text in the syntax of the function.
  • #VALUE! – If you enter a wrong type of argument in the syntax of the function, you will be getting this error in Microsoft Excel.
  • #REF! – Microsoft Excel will display this error if the formula refers to a cell that is not valid.

Things to Remember

  • It returns the integer position of the number.
  • It rounds down the decimal number to its integer.
  • It is categorized under Math & Trig function.
  • If you use the Integer function, negative numbers become more negative because it rounds down the number. For example, INT (10.6) returns 10 and INT (-10.6) returns -11.

Recommended Articles

This has been a guide to INT Function in Excel. Here we discuss the Integer Formula in excel and how to use it in excel along with excel example and downloadable excel templates. You may also look at these useful functions in excel –

  • VBA INT Function
  • VBA Integer
  • SMALL Function in Excel
  • ROUNDUP Function in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Login

Forgot Password?

WallStreetMojo

Download INT Function in Excel

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More