Sales targets and commissions

The sales manager's sheet: % of target, a commission that changes when the target is hit, a ranking with RANK, the top seller with INDEX and MATCH and a target vs. actual chart.

Area: Sales. Level: Intermediate.

Functions used: IF, RANK, SUM, INDEX, MATCH, MAX.

• Next project: Renovation budget
• All projects
• Lessons