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