Quick Navigation

INT Function

Excel 2007+

Summary

The Excel INT function rounds a number down to the nearest integer, always truncating toward zero for positive numbers and away from zero for negative numbers. It's essential for extracting whole numbers from decimal values in financial calculations, data processing, and statistical analysis.

Syntax

INT(number)

Parameters

Parameter	Type	Required	Description
number	`Number`	Yes	The value to round down. Positive numbers round toward zero, negative numbers round away from zero.

Using the INT Function

INT is perfect for scenarios requiring whole numbers only, such as calculating complete work hours from total time, determining full inventory units, or preparing data for integer-based calculations. It consistently floors values regardless of sign convention.

Common INT Examples

Basic Rounding Examples

=INT(8.9)

Rounds 8.9 down to 8

Negative Number Handling

=INT(-8.9)

Rounds -8.9 down to -9 (away from zero)

Extract Decimal Portion

=A1-INT(A1)

Returns fractional part of number in A1 (e.g., 19.5 becomes 0.5)

Frequently Asked Questions

INT always rounds toward negative infinity (floors), while TRUNC removes decimals toward zero regardless of sign.

INT returns the same integer unchanged.

Common Errors and Solutions

#VALUE!

Cause: Non-numeric input provided

Solution: Ensure the number argument contains valid numeric data

Notes

For positive numbers: INT(8.9) = 8
For negative numbers: INT(-8.9) = -9
Use =number-INT(number) to extract decimal portion
Does not round up - use CEILING or ROUNDUP for that behavior

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in:

Content last reviewed: December 11, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+