Invoice with tax
Build a complete invoice from scratch: price excluding tax, fill-down, subtotal, tax and total due — 5 guided steps using SUM and basic arithmetic.
= unit price × quantity
1 / 5
Price excluding tax of the first item (unit price × quantity)
=C9*D9
2 / 5
Fill down the formula on the "Price excl. tax" column
=C13*D13
Write the formula in cell E15
3 / 5
Invoice total excluding tax
=SUM(E9:E13)
Write the formula in cell E16
4 / 5
Tax amount
=E15*D16
Write the formula in cell E17
5 / 5
Total amount with tax
=E15+E16
Your score is
Restart
