Lab › Excel Basics › Discount and Final Price
Discount and Final Price: Excel Lab
Lab 04 · BeginnerMultiplicationSubtraction
The task: Each item has a price and a discount %. Find the discount amount and the price the customer pays.
1 Watch how it is done
Step 1: Find the discount amount
=B4*C4- Click D4.
- Type =B4*C4 and press Enter.
- Drag the fill handle down.
Step 2: Find the final price
=B4-D4- Click E4.
- Type =B4-D4 and press Enter.
- Drag the fill handle down.
2 Your turn
Download the practice file. It has new numbers. Open it in Excel (or Google Sheets) and do the same steps.
3 Check your answers
Stuck? Download the solution file and compare it with yours.
Next lab: Student Marksheet →
Want the theory? Read the Excel Basics lessons →
← More Excel Basics labs · All lab categories
