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)  



ADVERTISEMENT
ADVERTISEMENT