The INT function rounds a number down to the nearest integer.
This can be useful when you need to get rid of the fractional part of a number and obtain only its integer part.
Syntax
INT(value)
Argument |
Description |
Permitted values |
|---|---|---|
value |
Number that needs to be rounded down to the nearest integer |
Any number or reference to a cell containing a number |
Example of use
Rounding a positive number
If cell A1 contains the number 5.7, you can round it down to the nearest whole number using the function:
=INT(A1)
Result: 5.
Rounding a negative number
=INT(-123.45)
Result: −124.
Notes
–The INT function always rounds down, regardless of the value of the fractional part.
–For negative numbers, the function increases the absolute value (-3.2 becomes -4).
–For positive numbers, the function discards the fractional part.
–If you need to round a number, you can also use the ROUND, ROUNDUP, and ROUNDDOWN functions.