J
Jim Shaw
Hi,
Is it possible to work out my commission?
Here is the table:
£ % £ per bracket Combined Commission
0-2000 5 100 100
2000 – 5000 10 300 400
5000 – 10000 15 750 1150
1000 – 15000 17 850 2000
15000 – 20000 20 1000 3000
20000+ 22
So if I were to bill £14,000, I would get 5% of £2000, 10% of £5000,
15% of £10000 and 17% of £4000 = commission of £1830.
I have an UGLY nested IF fomula, but there MUST be an easier way?
Thanks,
Jim
Is it possible to work out my commission?
Here is the table:
£ % £ per bracket Combined Commission
0-2000 5 100 100
2000 – 5000 10 300 400
5000 – 10000 15 750 1150
1000 – 15000 17 850 2000
15000 – 20000 20 1000 3000
20000+ 22
So if I were to bill £14,000, I would get 5% of £2000, 10% of £5000,
15% of £10000 and 17% of £4000 = commission of £1830.
I have an UGLY nested IF fomula, but there MUST be an easier way?
Thanks,
Jim