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

sales commission

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

Solution

Note: Write down the Name and sales of each salesman in A and B column. Suppose the sales amounts are in the screenshot.

sales commission calculation

For commission, calculation write down the rule in C8 cell for commission calculation

=IF(B8<=50000,0,IF(B8<=100000,B8*5%,IF(B8<=150000,B8*7%,

IF(B8<=200000,B8*10%,B8*12%))))

sales commission calculation

Now keep press “Fill Handle” under selection takes to C11 cell.

Write down the salary for each salesman from D8 to D11

salary

For Net salary calculation

Write down the rule in E8 cell for Net salary calculation

=C8+D8

Net salary

Now keep press “Fill Handle” under selection takes to E11 cell.

Learn More…