INT Function

Rounds a number down to the nearest whole number.

Category

Math & Trig

Available in

All versions, Microsoft 365

Returns

A whole number

Want to practice INT in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

INT drops the decimals by rounding down. For positive numbers that just removes the decimals; for negatives it goes one lower (−2.5 → −3).

A favourite trick: INT of a date-time returns just the date.

Syntax

=INT(number) Explain

Arguments

ArgumentRequired?What it does
numberYesThe number to round down.

Examples

Example 1 — Whole units

Whole kilograms from weights.

B2fx=INT(A2)
AB
1WeightWhole kg
28.98
312.212
4-2.5-3
=INT(A2) Explain

Example 2 — Date without the time

A2 holds 15/03/2026 14:30.

=INT(A2) Explain

Format the result as a date. The time part — the decimal — is gone.

Common mistakes

  • Negatives. INT(−2.5) is −3, not −2. Use TRUNC to simply chop off decimals.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.