Practice challenge
Add sales tax to a subtotal
#14
3 attempts remaining
BeginnerSalesTarget D2
A checkout sheet stores the subtotal and tax rate for each order.
Write a formula for D2 that returns the total after tax.
Add sales tax to a subtotal
Swipe horizontally to view the full table.
| A | B | C | D | |
|---|---|---|---|---|
| # | Order | Subtotal | Tax rate | Total |
| 2 | R-1001 | 86 | 8% | blank |
| 3 | R-1002 | 140 | 8% | blank |
| 4 | R-1003 | 52 | 6% | blank |
| 5 | R-1004 | 210 | 0% | blank |