How to Use INT Function in Excel - Practical Guide

Learn to use the INT function to round numbers down to the nearest integer. This essential formula removes decimal places without rounding up, perfect for inventory counts, age calculations, and financial reporting where you need whole numbers only.

Why This Matters

INT simplifies data by converting decimals to whole numbers instantly, essential for reports, inventory tracking, and calculations requiring integer values.

Prerequisites

•Basic understanding of Excel formulas and cell references
•Familiarity with the formula bar and function insertion

Step-by-Step Instructions

Open Excel and select your target cell

Click on the cell where you want the INT result to appear.

Type the INT formula

Enter =INT(number) where 'number' is your value or cell reference, e.g., =INT(A1) or =INT(7.89).

Press Enter to execute

Hit Enter and Excel calculates the integer value, removing all decimal places.

Copy the formula to other cells (optional)

Select the cell with your formula, copy (Ctrl+C), select the range, and paste (Ctrl+V) to apply to multiple rows.

Verify your results

Check that decimals are removed correctly and negative numbers round toward negative infinity (e.g., INT(-2.9) = -3).

Alternative Methods

TRUNC function

TRUNC also removes decimals but differs with negative numbers; INT rounds toward negative infinity while TRUNC rounds toward zero.

ROUNDDOWN function

ROUNDDOWN(number, 0) achieves the same result but requires specifying 0 decimal places explicitly.

FLOOR function

FLOOR.MATH rounds down to the nearest integer with more control over significance parameter.

Tips & Tricks

✓INT always rounds down; for standard rounding, use ROUND function instead.
✓Negative numbers with INT round away from zero (INT(-3.2) = -4), not toward zero.
✓Combine INT with other functions like =INT(A1/100) to extract hundreds digits from large numbers.

Pro Tips

★Use INT in financial calculations to convert fractional shares into whole units without overrounding.
★Nest INT with division to create age calculators: =INT((TODAY()-DOB)/365.25) gives accurate age in years.
★Combine INT with MOD to extract integer and decimal parts separately in quality control applications.

Troubleshooting

INT returns #VALUE! error

Ensure the input is a number, not text. Check the cell doesn't contain spaces or text characters; convert text to numbers using VALUE function if needed.

Negative numbers aren't rounding as expected

Remember INT rounds toward negative infinity (down), so -2.3 becomes -3. Use TRUNC if you need rounding toward zero instead.

Formula isn't copying to other cells correctly

Use absolute references (=INT($A$1)) for fixed values or relative references (=INT(A1)) for dynamic rows; adjust after copying as needed.

Related Excel Formulas

TRUNC ROUND ROUNDDOWN FLOOR CEILING MOD

Frequently Asked Questions

What's the difference between INT and TRUNC?

INT rounds toward negative infinity (down), so INT(-2.5) = -3. TRUNC removes decimals toward zero, so TRUNC(-2.5) = -2. Use INT for financial data and TRUNC for truncation toward zero.

Can INT work with negative numbers?

Yes, INT works with negative numbers but rounds away from zero (toward negative infinity). INT(-3.2) returns -4, not -3. Use TRUNC if you need different behavior.

Is INT the same as rounding to zero decimals?

No. ROUND(7.8, 0) = 8 (rounds up), but INT(7.8) = 7 (always rounds down). INT always truncates; ROUND follows standard rounding rules.

How do I use INT in real-world scenarios?

Use INT for age calculations (=INT((TODAY()-DOB)/365.25)), inventory counts, financial reporting, extracting whole dollars, or calculating complete project weeks. Any scenario requiring whole numbers benefits from INT.