When you need to calculate sales commission of employee of any garments, showroom, or any sales and marketing company definitely you must read this article at the last point. Then you’ll learn how to calculate sales commission easily. It’s a very easy process to follow step by step.
Prerequisite of The Project
Calculate Sales commission in excel, based on these requirements. To know more about Excel formula and function you may take a tour on this link…
1. The commission is 0 when sales are less than or equal 50000
2. The commission is 5% when sales are less than or equal 100000
3. The commission is 7% when sales are less than or equal 150000
4. The commission is 10% when sales are less than or equal 200000
Note: Write down the Name and sales of each salesman in A and B column. Suppose the sales amounts are in the screenshot.
For commission, calculation write down the rule in C8 cell for commission calculation
Now keep press “Fill Handle” under selection takes to C11 cell.
Write down the salary for each salesman from D8 to D11
For Net salary calculation
Write down the rule in E8 cell for Net salary calculation
Now keep press “Fill Handle” under selection takes to E11 cell.