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.
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.
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.
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 Function ⋙ rounds to the nearest specified multiple.
- ROUNDUP Function ⋙ rounds up a numerical value to a specific decimal place.
- ROUNDDOWN Function ⋙ rounds down a numerical value to a specific decimal place.
- CEILING Function ⋙ rounds 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 Function ⋙ removes 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!