Lab › Formulas & Functions › Salesman Bonus (Slab)
Salesman Bonus (Slab): Excel Lab
Lab 09 · IntermediateVLOOKUP (approximate match)$ absolute reference
The task: Bonus depends on sales: 30,000+ gets 1,500, 50,000+ gets 3,000, 80,000+ gets 5,000. Find each person's bonus and total pay.
1 Watch how it is done
Step 1: Look up the bonus
=VLOOKUP(C4,$G$4:$H$7,2,TRUE)- Click D4.
- Type =VLOOKUP(C4,$G$4:$H$7,2,TRUE) and press Enter.
- Drag the fill handle down.
Step 2: Add salary and bonus
=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: Salary Sheet: DA, HRA, PF →
Want the theory? Read the Formulas & Functions lessons →
← More Formulas & Functions labs · All lab categories
