Commission Payment Spreadsheet

[trickeyd93]

Hi Guys, Thanks for reading.

My friend has recently been given a new pay structure and needs help putting together a simple spreadsheet to calculate how much he should be getting paid based on the saled.

What he does is door to door selling of Gas & Electric, and there are two types of sale. Direct Debit and PPM.

I did one which works and is being used at the moment. However he did ask to see if this could be simplified (for him)

He wants to be able to put in how many sales in DD & PPM into two columns with rows monday to friday. with total of sales at the bottom which will calculate his wages automatically.

The problem here is when he reaches 20 sales his commission increased and again at 59 and 75.

Can somebody help me to create a spreadsheet which will tot up the weekly sales and dependent on the total value calculate the "what should be" commission.