INT Function


INT function in Excel is used to round down a decimal number to the nearest integer.

Function Type

Math and trigonometry


Get the integer part of a number after rounding it down.

Return value

Number equivalent to the rounded number




number – The number to round down as integer

Example 1


INT function always rounds down the number. To get the integer part of a negative number, use TRUNC function.

Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)

New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel