Hi everyone,

I am trying to setup a excel sheet to calculate sales reps commissions, the
more they sell the higher the banding becomes.
<6500 profit = 5% commission
between 6501 & 8000 = 7%
between 8001 & 10'000 = 10
10k to 12.5k = 12%
12.5k to 15k = 15%
over 15k = 20%

Example -
if they earn £10'000 - they get 5% first £6500 (£325), 7% of the next £1500
(£134) etc

Can anyone help me with a formula that will do this for me?

Thanks

Richard