INT Function
Rounds a number down to the nearest integer.
Syntax
Parameters
| Parameter | Description | Required |
|---|---|---|
| number | The real number you want to round down to an integer. | Required |
Basic Example
Round 4.3 down
=INT(4.3)4 is the largest integer less than or equal to 4.3.
Advanced Examples
Example 1: Negative numbers go down
Rounding -4.3.INT always moves toward negative infinity, not toward zero.
=INT(-4.3)Example 2: Extract the integer part of a division
Integer division of 10 by 3.Combine with MOD for quotient and remainder.
=INT(10/3)How INT Works
INT returns the greatest integer that is less than or equal to the input. For positive numbers this drops the fractional part; for negatives it moves to the next lower integer. Unlike TRUNC, INT rounds toward negative infinity.
Important Notes & Limitations
INT always rounds down (toward negative infinity), so INT(-4.3) = -5, which surprises users expecting -4.
For simply dropping decimals without rounding, use TRUNC instead.
Result is still a floating-point number with .0.
Common Errors & Fixes
Unexpected negative resultINT rounds negatives down, not toward zero.Fix: Use TRUNC if you want to drop the sign-preserving fractional part.
#VALUE!Non-numeric argument.Fix: Supply a numeric value.
Download Practice File
INT
intPractice INT with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the INT function. Works in both Excel and Google Sheets.
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps