INT Function in Microsoft Excel: Examples, Pitfalls & Compatibility
INT in Microsoft Excel: round down toward negative infinity rather than merely remove decimal digits. Includes worked examples and application-specific cautions.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Microsoft Excel. How formula examples are checked
Quick answer: Use INT in Microsoft Excel to round down toward negative infinity rather than merely remove decimal digits. The official INT reference is the source for the function definition and platform-specific rules described below.
Syntax and arguments
=INT(number)
number (required): The numeric value whose lower integer boundary is needed.
Examples use English function names, comma argument separators and decimal points. Adapt formula separators to your workbook settings, not punctuation inside quoted text.
When to use it
Use INT for lower integer boundaries, whole nonnegative groups and floor-based buckets. For a negative number, down means farther below zero. Choose TRUNC when the requirement is to discard the fractional part toward zero instead.
Three worked examples
Each example is independent. Where input cells are listed, enter those values first; otherwise the formula is self-contained. Expected outputs are independently checked calculations or documented error expectations, not captured results from Microsoft Excel.
Example 1: Count complete positive groups
=INT(38/12)
Expected result: 3.
Three complete groups of 12 fit into 38 items. This does not calculate the number of containers required to hold all items.
Example 2: Apply the floor rule to a negative
=INT(-3.2)
Expected result: -4.
The greatest integer not above -3.2 is -4. Removing the decimal part toward zero would instead give -3.
Example 3: Create a lower hundred-unit bucket
=INT(245/100)*100
Expected result: 200.
Divide into hundred-unit intervals, take the lower integer boundary, then scale back to the original unit.
Put it to work safely
State whether the data can contain negatives before selecting a rounding function. A whole-carton calculation on valid positive stock and a floor calculation on signed measurements are different business problems. Put the divisor or bucket width in a clearly labelled positive input cell, and test a value immediately below a boundary as well as one exactly on it.
Common mistakes and fixes
A negative result is one less than expected. INT floors the value. Compare with TRUNC when the intended rule is toward zero.
A formatted integer is mistaken for a rounded value. Changing the number of displayed decimal places does not itself establish that the underlying value was changed. Inspect the calculation rather than relying on the display.
A group count is applied to invalid quantities. Validate nonnegative stock and a positive pack size before interpreting a floor result as usable inventory.
Microsoft Excel-specific notes
Microsoft explicitly contrasts negative rounding with truncation. The examples below use both a negative noninteger and a positive bucket so the rule can be tested before copying the formula to a workbook. See the vendor reference for the current definition.
Excel and Google Sheets comparison
The documented floor rule is consistent across these two applications for ordinary finite real numbers. Boundary precision, imported numeric text and date serials need separate checks; they are not covered by this small numeric test set.
Compare the INT guide for Google Sheets and its official documentation. Having a guide in both libraries establishes two documented references, not a certificate of identical behavior across releases, locales or file conversions.
Related guides
Evidence and testing scope
Editorial verification: Official references retrieved on 2026-10-12. The three worked cases are included in this release’s reproducible Python checking suite. It checks the stated arithmetic, calendar or text model and the expected documented error classification; it is not the Microsoft Excel calculation engine. No native application run, UI screenshot, maximum-size benchmark or cross-version certification is claimed. Review the editorial testing standards before relying on a formula in a critical workbook.