How do I use ROUNDDOWN in Excel?
Use ROUNDDOWN when you want to round a value down. Enter Number, Number of digits in that order, then add optional arguments when needed.
Excel Function
ROUNDDOWN
Rounds a number down.
ROUNDDOWN(number, num_digits)Arguments
number
RequiredSpecify a single cell reference.
num_digits
RequiredEnter a numeric value.
Practice Preview
Use ROUNDDOWN to truncate cell D2 (Amount in column D) to 0 decimal places (ROUNDDOWN moves toward zero, so negative values differ from INT).
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)
=ROUNDDOWN(D2, 0)Result
-361
Practice This Function
ROUNDDOWN FAQ
Where can I practice ROUNDDOWN?
Use the "Start Function Practice" button to jump straight into ROUNDDOWN drills.
What arguments does ROUNDDOWN use?
The main arguments are Number, Number of digits. Enter them in order.