Excel ROUND Practice Question: Round each price to the nearest 5 and put the results in C2 to C4.
The question
Round each price to the nearest 5 and put the results in C2 to C4.
The data
| A | B | C | |
|---|---|---|---|
| 1 | Item | Price | Nearest 5 |
| 2 | Cable | 1847 | ? |
| 3 | Hub | 763 | ? |
| 4 | Case | 12 | ? |
The yellow cells are where your answer goes.
Show answer
Expected results:
- C2 = 1845
- C3 = 765
- C4 = 10
How it works
Explanation: To round to a step like 5, divide by the step, round to a whole number, then multiply by the step again.
Syntax: =ROUND(B2/5,0)*5
1847 / 5 = 369.4, rounds to 369, x 5 = 1845. 763 / 5 = 152.6, rounds to 153, x 5 = 765. 12 / 5 = 2.4, rounds to 2, x 5 = 10.
Try it yourself in the live sheet
Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.
Try this question in the live sheet →ROUND syntax
=ROUND(number, num_digits)
Rounds a number to a set number of decimal places. ROUND is used in financial models and engineering-style calculations where precise numeric work is needed. Full ROUND guide.
More ROUND practice questions
- Using ROUND, round the amount in B2 to 2 decimal places and put it in C2.
- Round each weight to the nearest whole kg and put the results in C2 to C4.
- Using ROUND, round each price to the nearest 10 and put the results in C2 to C4.
- Find the GST on each invoice at the rate in E2, rounded to 2 decimals, and put it in C2…
- Find the average mark rounded to 1 decimal and put it in D2.
- The price after the discount in E2 must be a whole rupee amount. Find the final price…
- Round each line total (Qty x Price) to a whole number first, then add the rounded lines…
- Item prices (before tax) are in B2:B7. Calculate the total GST at 18% on all items,…
All practice questions · Excel exercises · Interview prep · Cheat sheet