Home › Practice questions › ROUND › Question 8

Excel ROUND Practice Question: Round each line total (Qty x Price) to a whole number first, then add the…

By Rinkesh Shah, founder of Cellgrids.

The question

Round each line total (Qty x Price) to a whole number first, then add the rounded lines up. Put the result in E2.

The data

	A	B	C	E
1	Line	Qty	Price	Total
2	A	3	4.4	?
3	B	5	2.2
4	C	7	6.9

The yellow cell is where your answer goes.

Show answer

Answer in E2: 72

How it works

Explanation: Rounding every line first can give a different total than rounding the grand total. SUMPRODUCT lets ROUND work on every row at once.
Syntax: =SUMPRODUCT(ROUND(B2:B4*C2:C4,0))
Line totals: 3x4.4 = 13.2 gives 13, 5x2.2 = 11 gives 11, 7x6.9 = 48.3 gives 48. Total = 13 + 11 + 48 = 72. Rounding the unrounded total of 72.5 would give 73.

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.