Math function
Excel INT function
INT rounds a number down to the nearest whole number. For positive numbers it simply drops the decimals. For negative numbers it goes further down, so -2.3 becomes -3.
=INT(number)Arguments
number- The number or cell to round down to an integer.
INT examples
Every result below was calculated from this sample sheet by the same spreadsheet engine the Cellwise app uses.
| A | B | C | |
|---|---|---|---|
| 1 | Employee | Hours | Age (years) |
| 2 | Jordan | 37.75 | 29.6 |
| 3 | Mei | 41.25 | 34.2 |
| 4 | Carlos | 22.5 | 51.9 |
Result: 37
The whole hours Jordan worked, with the partial hour dropped.
Result: 45
Subtract the whole part to get the leftover fraction, then convert it to minutes.
Result: 51
Age in completed years. 51.9 is still 51.
Result: -3
For negatives INT rounds down to the lower number, so -2.3 becomes -3.
How to use INT
- Click an empty cell.
- Type =INT(
- Select the cell or type the number.
- Close the bracket and press Enter.
Common INT mistakes
Expecting -2.3 to give -2
INT always goes down, so it returns -3. Use TRUNC or ROUNDDOWN(x,0) to cut toward zero.
Using INT to round to the nearest
INT(4.9) is 4, not 5. Use ROUND(x,0) for nearest-number rounding.
Splitting date and time wrong
A date-time is a number, so INT returns just the date part. Format the result as a date, not a number.
INT FAQ
What does INT do in Excel?
It rounds a number down to the nearest integer. INT(8.9) is 8 and INT(-8.9) is -9.
What is the difference between INT and TRUNC in Excel?
For positive numbers they match. For negatives, TRUNC just removes the decimals (-8) while INT rounds down (-9).
How do I get just the decimal part of a number?
Subtract INT from the number: =A1-INT(A1). For positive numbers you can also use =MOD(A1,1).
Related functions
Updated