Excel INT Function (Round Down to Integer) – Examples & Practice
Practice the Excel INT function online with an interactive grid, instant feedback, and clear formula help.
Instruction
Round down the value in B4 to the nearest integer.
Formula Syntax
=INT(number)
- number: The real number you want to round down to an integer.
What it does
INT rounds a number down to the nearest integer. It is often used to remove fractional parts from positive measurements or to strip time from datetime serials.
Excel INT Function Examples
Integer part of a positive number
=INT(B4)
Turns 9.7 into 9.
Strip time from a datetime
=INT(A2)
Keeps the date portion when A2 is a datetime serial.
Bucket numbers to thousands
=INT(B2/1000)*1000
Floors values to the nearest thousand for banded dashboards (change 1000 to match your bucket size).
numeric-practice-sheet.xlsx
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Input 1 | 120 |
| 3 | Input 2 | -45 |
| 4 | Input 3 | 560.25 |
| 5 | Input 4 | 225.8 |
| 6 | Input 5 | 90 |
| 7 | Output |
Input Formula
Need Help?
Tips
- Test INT on negative examples relevant to your model.
- Prefer explicit business rules (ROUND/CEILING) when money is involved.
- Document whether datetime truncation is intended.
INT Function Use Cases
- Buckets for age or tenure bands
- Whole-unit inventory planning
- Date-only extraction from timestamps
- Floor-like pricing tiers (verify business rules)
- Simplify values before lookups
Common mistakes - INT function not working
- Using INT when ROUND is the business rule
- Surprises with negative fractional inputs
- Expecting INT to round to tens (use ROUND with negative digits)
- Confusing INT with integer storage in cells
- Forgetting time removal impacts on schedules
FAQ
INT vs TRUNC?
For positive numbers they behave similarly toward zero; differences show up with negatives depending on method—verify with your Excel version.
Does INT work on dates?
Dates are serial numbers; INT can strip time from a date-time value in many workflows.
Does INT round toward negative infinity?
INT rounds down toward negative infinity for fractional negatives in classic behavior—test with your data.
INT vs ROUND?
INT always moves down to the next integer for positive fractions; ROUND follows normal rounding rules.
Can INT remove decimals only?
Yes, for positive values INT drops the fractional part.
Comparison
| Function | Typical use |
|---|---|
| INT | Floor-like integer |
| ROUND | Nearest rounding |
| TRUNC | Cut off decimals |
Example
=INT(8.9) returns 8.
Advanced examples
INT with MOD for grouping
Classic grouping patterns combine INT division with MOD for binning rows.