The INT function rounds a number down to the nearest whole number by removing the decimal portion. It always returns the largest integer that is less than or equal to the given number, including for negative values.
=INT(number)What does INT do?
The INT function in Excel is a simple but powerful math tool that rounds any number down to a whole number. Unlike rounding that goes to the nearest value, INT always moves toward the lower integer, so 7.9 becomes 7 and -3.1 becomes -4. It takes one argument, the number you want to round, and returns an integer.
You will use INT whenever you need to discard fractional parts—like when you have prices with cents but only want whole pounds, or when you are calculating complete time periods such as full days or months. It is especially handy for grouping values into buckets, such as age bands or sales tiers, because it consistently floors the result.
Imagine you manage a small shop and track daily sales with decimals. You want to know how many complete units were sold each day, ignoring partial units. INT quickly converts each decimal figure to a whole number, making your reports cleaner and easier to read. It also works well for calculating whole weeks from a number of days or whole hours from minutes.
When to use INT
- Removing decimals from prices to show whole currency units.
- Calculating complete time periods, such as full days from hours or full weeks from days.
- Grouping numbers into bands, like age ranges or sales tiers, by flooring the value.
- Extracting the integer part of a number for further calculations.
- Converting negative measurements to the next lower whole number for consistent reporting.
INT syntax
=INT(number)| Argument | Required? | What to enter |
|---|---|---|
number | Required | The numeric value you want to round down. It can be a number, a cell reference, or a formula that returns a number. For example, =INT(5.7) returns 5. |
What it returns: The largest integer less than or equal to the given number. For positive numbers, it simply removes the decimal part; for negative numbers, it rounds away from zero (e.g., -2.3 becomes -3).
INT examples
1 Basic rounding down of a positive decimal
This example shows how INT handles a simple positive decimal. The goal is to convert 7.8 to a whole number by rounding down. The formula =INT(B2) takes the value in cell B2 (7.8) and returns the largest integer less than or equal to it, which is 7. It ignores the decimal part entirely, so the result is 7.
| A | B | C | |
|---|---|---|---|
| 1 | Value | Result | |
| 2 | 7.8 | 7 | |
| 3 |
2 Rounding down a negative number
INT behaves differently with negative numbers: it rounds away from zero. Here, the value is -3.2 in cell A2. The formula =INT(A2) returns -4, because -4 is the largest integer less than or equal to -3.2. This is useful when you need consistent flooring for negative values, such as temperature readings or losses.
| A | B | C | |
|---|---|---|---|
| 1 | Value | Result | |
| 2 | -3.2 | -4 | |
| 3 |
3 Calculating full weeks from total days
Suppose you have a project lasting 45 days and want to know how many complete weeks that is. Each week has 7 days, so you divide the total days by 7 and then apply INT to round down to whole weeks. The formula =INT(B2/7) divides 45 by 7 (which gives about 6.43) and returns 6, meaning there are 6 full weeks and a remainder of 3 days.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Project | Total Days | Full Weeks | |
| 2 | Alpha | 45 | 6 | |
| 3 |
4 Extracting whole currency units from prices
In a price list, you might want to show only the whole pound (or dollar) amount, ignoring pence or cents. For a price of 19.99 in cell B2, the formula =INT(B2) returns 19. This is handy for creating simplified price tags or for calculations that require whole units. The decimal part is simply dropped.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Product | Price | Whole Units | |
| 2 | Widget | 19.99 | 19 | |
| 3 |
5 Grouping ages into bands using INT
You can use INT to assign people to age bands of 10 years. For a person aged 34 in cell B2, the formula =INT(B2/10)*10 divides 34 by 10 (3.4), rounds down to 3, and multiplies by 10 to get 30. This means the person falls into the 30–39 band. The result is the lower bound of the band, which is useful for summarising data.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Age | Age Band | |
| 2 | Alice | 34 | 30 | |
| 3 |
Common INT errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #VALUE! | The argument is text that cannot be converted to a number, such as a word or a date stored as text. | Ensure the cell contains a number or a reference to a numeric cell. Use VALUE to convert text numbers if needed. |
| #NAME? | The function name is misspelled, for example =INTT(5.7). | Check the spelling: it should be INT. |
| #NUM! | The argument is a number too large or too small for Excel to handle, or a calculation results in an invalid number. | Verify that the input is within Excel's numeric limits and that any nested calculations are valid. |
| Wrong result for negative numbers | INT rounds negative numbers away from zero, which may surprise users expecting truncation toward zero. | If you want to truncate toward zero for negatives, use TRUNC instead. |
Tips for using INT
- Use INT when you need the floor of a number, especially for grouping or banding data.
- Remember that INT rounds negative numbers down (away from zero), so -1.1 becomes -2.
- Combine INT with division to count complete periods, like full weeks from days.
- To round to a specific multiple, divide by that multiple, apply INT, then multiply back.
- INT is not the same as formatting to zero decimals; it changes the underlying value.
Frequently asked questions
What is the difference between INT and ROUND?
INT always rounds down to the nearest whole number, while ROUND rounds to the nearest whole number based on the decimal part. For example, INT(2.9) returns 2, but ROUND(2.9,0) returns 3.
How does INT handle negative numbers?
INT rounds negative numbers down, away from zero. So INT(-2.3) returns -3, because -3 is the largest integer less than or equal to -2.3.
Can I use INT with dates or times?
Yes, because Excel stores dates and times as numbers. INT can extract the date part from a date-time value, effectively removing the time.
What happens if I use INT on a cell with text?
If the text cannot be interpreted as a number, INT returns the #VALUE! error. Make sure the cell contains a numeric value.
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. INT reference