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 result with these settings (Number: D2 (cell D2 (Amount in column D))).
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 | S005 | 150.9 | 6 | 905.4 |
| 7 | ||||
| 8 |
How to Use (Formula)
=INT(D2)Result
361
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.