How do I use INT in Excel?
Use INT when you want to convert decimals into integers. Enter Number in that order, then add optional arguments when needed.
Excel Function
INT
Rounds number down to nearest integer.
INT(number)Arguments
number
RequiredSpecify a single cell reference.
Practice Preview
Use INT to return the largest integer that does not exceed cell D2 (Amount in column D) (for negative values this is one lower than ROUNDDOWN).
Example Table
| # | ASlip ID | BUnit Price | CQuantity | DAmount |
|---|---|---|---|---|
| 2 | S001 | 120.5 | 3 | -361.5 |
| 3 | S002 | 98.2 | 5 | 491 |
| 4 | S003 | 450.7 | 2 | 901.4 |
| 5 | S004 | 300.4 | 4 | 1201.6 |
| 6 | ||||
| 7 | ||||
| 8 |
How to Use (Formula)
=INT(D2)Result
-362
Practice This Function
INT FAQ
Where can I practice INT?
Use the "Start Function Practice" button to jump straight into INT drills.
What arguments does INT use?
The main arguments are Number. Enter them in order.