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 return the result with these settings (Number: D2 (cell D2 (Amount in column D)), Number of digits: 0).
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)
=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.