Table of Contents
The INT function in Excel is a mathematical formula that allows users to round down a decimal number to the nearest integer. This function is useful in situations where whole numbers are needed, such as in financial calculations or data analysis. By using the INT function, the decimal portion of a number will be dropped, resulting in a whole number. This feature can be particularly helpful in simplifying complex calculations and providing more accurate results. To use the INT function, simply enter the formula “=INT(number)” into a cell, where “number” is the decimal value that needs to be rounded down. The result will be displayed as the nearest integer value. This function is a powerful tool that can save time and improve the accuracy of data analysis in Excel.
This article describes the formula syntax and usage of the INT function in Microsoft Excel.
Description
Rounds a number down to the nearest integer.
Syntax
INT(number)
The INT function syntax has the following arguments:
Number Required. The real number you want to round down to an integer.
Example
Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.
Data | ||
|---|---|---|
19.5 | ||
Formula | Description | Result |
=INT(8.9) | Rounds 8.9 down | 8 |
=INT(-8.9) | Rounds -8.9 down. Rounding a negative number down rounds it away from 0. | -9 |
=A2-INT(A2) | Returns the decimal part of a positive real number in cell A2 | 0.5 |
Cite this article
stats writer (2024). How can I use the INT function in excel to round down a decimal number to the nearest integer?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-int-function-in-excel-to-round-down-a-decimal-number-to-the-nearest-integer/
stats writer. "How can I use the INT function in excel to round down a decimal number to the nearest integer?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-int-function-in-excel-to-round-down-a-decimal-number-to-the-nearest-integer/.
stats writer. "How can I use the INT function in excel to round down a decimal number to the nearest integer?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-int-function-in-excel-to-round-down-a-decimal-number-to-the-nearest-integer/.
stats writer (2024) 'How can I use the INT function in excel to round down a decimal number to the nearest integer?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-int-function-in-excel-to-round-down-a-decimal-number-to-the-nearest-integer/.
[1] stats writer, "How can I use the INT function in excel to round down a decimal number to the nearest integer?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the INT function in excel to round down a decimal number to the nearest integer?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.