Excel Practice - ROUND
Instruction
Round the number in B4 to 1 decimal place.
Formula Syntax
=ROUND(number, num_digits)
- number: Numeric value or numeric reference.
- num_digits: Number of decimal places for rounding.
What it does
Round values to a specific number of digits.
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
- Use ROUND with clean and consistent ranges for predictable results.
- Validate data types (number, text, date) before applying the formula.
- Test the formula with a small sample first, then scale it to larger ranges.