Excel ROUND Function (Round to Digits) – Examples & Practice
Practice the Excel ROUND function online with an interactive grid, instant feedback, and clear formula help.
Instruction
Round the number in B4 to 1 decimal place.
Formula Syntax
=ROUND(number, num_digits)
- number: The number you want to round.
- num_digits: Decimal places to keep; negative rounds left of the decimal.
What it does
ROUND rounds a number to a specified number of digits. It is the standard tool for financial display and controlled precision.
Excel ROUND Function Examples
Two decimal places
=ROUND(B4, 2)
Rounds a currency value to cents.
Round to tens
=ROUND(A2, -1)
Rounds to the nearest ten.
numeric-practice-sheet.xlsx
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Input 1 | 120 |
| 3 | Input 2 | -45 |
| 4 | Input 3 | 560.25 |
| 5 | Input 4 | 225.8 |
| 6 | Input 5 | 90 |
| 7 | Output |
Input Formula
Need Help?
Tips
- Decide whether to round line items or totals for reporting consistency.
- Pair with ABS when rounding magnitudes.
- Use TEXT for display formatting without changing numeric values.
ROUND Function Use Cases
- Currency and tax display rules
- Normalize measurements for reporting
- Prepare values for export with fixed precision
- Reduce noise in charts
- Teaching rounding vs truncation
Common mistakes - ROUND function not working
- Confusing ROUND with formatting-only changes
- Using ROUND when INT or TRUNC is required
- Rounding too early in multi-step finance models
- Expecting bankers rounding in all edge cases without testing
- Forgetting negative num_digits for large rounding
FAQ
What does num_digits mean?
It is how many decimal places to keep. Negative values round to tens, hundreds, etc.
ROUND vs ROUNDUP vs ROUNDDOWN?
ROUND follows standard rounding rules; ROUNDUP and ROUNDDOWN always move away or toward zero.
Does ROUND change the stored value?
The formula result is rounded; underlying source cells are unchanged.
Can I round to thousands?
Yes. Use a negative num_digits such as -3.
Why do rounded totals still look off?
Rounding each line then summing can differ from rounding the total; choose a policy.
Comparison
| Function | Behavior |
|---|---|
| ROUND | Standard rounding |
| INT | Rounds down to integer |
| TRUNC | Truncates digits |
Example
=ROUND(3.14159, 2)
Advanced examples
Round to a step
Divide, ROUND, multiply pattern:
=ROUND(A2/5,0)*5 rounds to nearest multiple of 5.