Excel ROUND Practice Question: The price after the discount in E2 must be a whole rupee amount. Find the…
The question
The price after the discount in E2 must be a whole rupee amount. Find the final price for the quantity and price in row 2, and put it in F2.
The data
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Item | Qty | Price | Discount | Final | |
| 2 | Cable | 7 | 349 | 0.125 | ? |
The yellow cell is where your answer goes.
Show answer
Answer in F2: 2138
How it works
Explanation: Work out the full price first, take off the discount, then round the final result once at the end.
Syntax: =ROUND(B2*C2*(1-E2),0)
7 x 349 = 2443. 2443 x (1 - 0.125) = 2137.625. Rounded to a whole number: 2138.
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
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…
- Round each price to the nearest 5 and put the results in C2 to C4.
- Find the average mark rounded to 1 decimal and put it in D2.
- 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