Hi

I have a Sliding Scale Commission that I pay my staff. 

They have to submit an invoice to me to show how much sales have been done and then how much I need to pay them in commission. 

I would like to create a generic Excel spreadsheet that they complete the total sales amount and it works out their commission pay in another box. 

The scale is:

£0-£2000 @ 15%
£2000-£3000 @ 16%

£3000-£4000 @ 17%
£4000+ @18%

So for example, if their sales is £2500:

they would get 15% of the £2000 = £300

then they would get 16% on the £500 = £80

so I would pay them £380

Is there a way to do this? 

TIA

​Hi I have a Sliding Scale Commission that I pay my staff. They have to submit an invoice to me to show how much sales have been done and then how much I need to pay them in commission. I would like to create a generic Excel spreadsheet that they complete the total sales amount and it works out their commission pay in another box. The scale is:£0-£2000 @ 15%£2000-£3000 @ 16%£3000-£4000 @ 17%£4000+ @18%So for example, if their sales is £2500:they would get 15% of the £2000 = £300then they would get 16% on the £500 = £80 so I would pay them £380 Is there a way to do this? TIA  Read More

​