Price with tax: the absolute reference $
Calculate net total, tax and total including tax on a grocery order, learning to lock a tax-rate cell with the $ absolute reference so fill-down stays correct — 7 guided steps.
Write the formula in cell D2
1 / 7
Net total = price × quantity
=B2*C2
2 / 7
Fill the Net total down (column D)
=B7*C7
Lock the rate with $ (F4) — cell E2
3 / 7
Tax = Net total × $B$9 (absolute reference)
=D2*$B$9
4 / 7
Fill the Tax down (column E)
=D7*$B$9
Write the formula in cell F2
5 / 7
Total incl. tax = Net total + Tax
=D2+E2
6 / 7
Fill the Total incl. tax down (column F)
=D7+E7
Use the SUM function in cell F10
7 / 7
Total to pay = SUM of the totals incl. tax
=SUM(F2:F7)
Your score is
Restart
