An Overview of INT Function | Microsoft Excel

The INT function is one of the math and trigonometry functions in Microsoft Excel. It can be used as a standalone function and in collaboration with the other functions. This article will give you an overview of the INT function in Excel.

Objectives

The INT function rounds down a numerical value to the nearest integer number. It removes the fraction part of a decimal fraction number. Thus, the output becomes a rounded-down version of the input number.

Syntax

=INT(number)

Arguments

  • number: It refers to the number to round down.

Output

A rounded-down version of the input number.

Examples of INT Function

Suppose, you have the number 3.4 in cell A2. Using the INT function, you can round down the number to the nearest integer number. The INT function clears the part after the decimal point. So, the output becomes an integer version of the input number. Now, use the formula:

=INT(A2)

The output will be 3.

Here are some examples of the usage of the INT function.

An Overview of INT Function in Microsoft Excel

Usage Guide of INT Function

Step_1: Start with inserting an equal sign (=) in a blank cell.

Step_2: Then type INT.

Step_3: Type open parenthesis “(“.

As you type the open parenthesis, Excel shows the syntax of the INT function.

Usage Guide of INT Function in Excel

Step_4: Insert a number to round down to the nearest integer.

You can directly insert a number or a cell address that contains a number.

Here, I have inserted cell A2 which contains a decimal fraction number, 3.4.

Usage Guide of INT Function in Excel

Final Result

The INT function converts 3.4  into 3. It removes the decimal fraction part from 3.4. Thus, the output becomes 3. As the INT function removes the fraction part of a number, the output is always a rounded-down version of the input number.

Availability

  • Excel for Microsoft 365
  • Excel 2016
  • Excel for Microsoft 365 for Mac
  • Excel 2016 for Mac
  • Excel for the web
  • Excel 2013
  • Excel 2021
  • Excel 2010
  • Excel 2021 for Mac
  • Excel 2007
  • Excel 2019
  • Excel for Mac 2011
  • Excel 2019 for Mac
  • Excel Starter 2010

Remarks

  • The INT function shows #VALUE! error in the case of the non-numeric values.
  • It returns 0 for the fraction numbers that are less than 1.
  • It returns -1 for the negative fraction numbers in the range -0.1 to -0.99.
  • When an input number is already an integer number, the INT function doesn’t bring any change in the output.

Related Rounding Functions

  • ROUND Function rounds to the given number of decimal places.
  • MROUND Functionrounds to the nearest specified multiple.
  • ROUNDUP Function ⋙ rounds up a numerical value to a specific decimal place.
  • ROUNDDOWN Functionrounds down a numerical value to a specific decimal place.
  • CEILING Functionrounds up a numerical value to the nearest integer or the nearest multiple of significance.
  • FLOOR Function rounds down a numerical value to the nearest multiple of significance.
  • TRUNC Functionremoves specific digits from the fraction part of a number.

Conclusion

The INT function is one of the math and trigonometry functions in Excel. If you have any questions regarding the INT function, please comment below. Thanks!

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *