Excel ROUND Practice Question: Find the GST on each invoice at the rate in E2, rounded to 2 decimals, and put…
The question
Find the GST on each invoice at the rate in E2, rounded to 2 decimals, and put it in C2 to C4.
The data
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Invoice | Amount | GST | GST rate | |
| 2 | INV-1 | 1249.37 | ? | 0.18 | |
| 3 | INV-2 | 860.55 | ? | ||
| 4 | INV-3 | 2310.9 | ? |
The yellow cells are where your answer goes.
Show answer
Expected results:
- C2 = 224.89
- C3 = 154.9
- C4 = 415.96
How it works
Explanation: Tax in a bill must be a real paise amount, so round the result of the multiplication to 2 decimals. $E$2 stays fixed when you copy the formula down.
Syntax: =ROUND(B2*$E$2,2)
1249.37 x 0.18 = 224.8866, which rounds to 224.89. 860.55 x 0.18 = 154.899, which rounds to 154.90. 2310.9 x 0.18 = 415.962, which rounds to 415.96.
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.
- 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.
- 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