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) |