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