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)