# Excel INT() Function

Excel INT() Function

The INT() function in excel is used to round a number down to the nearest integer. It removes decimal points from any number value & return rounded down number value in the cell.

Syntax

`INT(Number)`

Parameter

Number(required)- This parameter represents the number for which you want round down the value in the cell.

Category

Math & Trig

Returns

This function returns the rounded down number value in the cell.

Example 1

Objective: Use INT function to reduce the decimal places of the number to integer value.

 Numbers Rounded Formula 45.3976106 45.00 =INT(A18) 50.6546265 50.00 =INT(A19) 85.9139093 85.000 =INT(A20) 33.5893471 33 =INT(A21)

Example 2

Objective: Round a negative value mentioned in cells and extract integer portion

 Items Result Formula -81.373 -82.00 =INT(A26) -7.9597 -8.00 =INT(A27) -521.2578 -522.00 =INT(A28) -4.699 -5.00 =INT(A29)

Example 3

Objective: Extract date only from date and time given in cell

 Value Result Formula 31-December-2019 13:29 31-December-2019 =INT(E121)