INT
Rounds a number down to the nearest integer.
INT(number)Arguments
numberThe number to round down
=INT(5.9)Rounds 5.9 down to 5
=INT(-5.9)Rounds -5.9 down to -6
=A1-INT(A1)Extracts the decimal portion
- •Always rounds toward negative infinity
- •Use TRUNC to simply remove decimals
- •For positive numbers, same as TRUNC
- •Assuming INT rounds to the nearest whole number - it doesn't, it always rounds down toward negative infinity, which surprises people expecting normal rounding behavior
- •Using INT on a negative number and expecting it to truncate toward zero like TRUNC does - INT(-4.3) returns -5, not -4
- •Applying INT to a date-and-time value to isolate the date, then being surprised that formatting doesn't automatically switch from a time format to a date format
TRUNCCuts off the decimal portion toward zero instead of always rounding down, which behaves differently for negative numbers.ROUNDRounds to the nearest value using standard rounding rules, rather than always rounding down.MODOften paired with INT to fully decompose a division into whole part and remainder.What's the difference between INT and TRUNC?
For positive numbers they're identical. For negative numbers, INT always rounds down (more negative), while TRUNC just chops off the decimal, moving toward zero. INT(-4.3) is -5, TRUNC(-4.3) is -4.
How do I get just the date from a date-and-time value?
INT(A1) strips the time portion, leaving just the whole-number date. You may need to reapply date formatting afterward.
Does INT round to the nearest whole number?
No, it always rounds down toward negative infinity, regardless of how close the decimal is to the next whole number. Use ROUND for standard nearest-value rounding.
Need to translate a formula using INT?
Use our translator to convert your complete formula