Practice challenge
Apply a percentage discount
#2
3 attempts remaining
BeginnerProduct pricingTarget D2
A sales sheet lists the original price and discount rate for each item.
Write a formula for D2 that returns the final price after applying the discount.
Apply a percentage discount
Swipe horizontally to view the full table.
| A | B | C | D | |
|---|---|---|---|---|
| # | Item | Price | Discount | Final price |
| 2 | Notebook | 18 | 10% | blank |
| 3 | Desk Lamp | 42 | 15% | blank |
| 4 | Planner | 24 | 0% | blank |
| 5 | Marker Set | 16 | 25% | blank |