Skip to main content

INT

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)

ArgumentDescriptionPermitted values
valueNumber that needs to be rounded down to the nearest integerAny 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.