Commission Calculator
Budget: £10 – £20 GBP
I am looking to have an excel commission calculator created.
The formula is quite simple.
My work earn commission from £8K
Invoice Value £0 - £10,000 = 10%
£10,001 - £20,000. = 12.5%
£20,001 - £40,000. = 15%
£40,001 - £75,000. = 20%
£75,001.00. = 25%
So for example,
£10K (£10K - £8K, £2K * 10%)) = £200
£20K (£20K - £8K, £12K * 12.5%) = £1500
£30K (£22K * 15%) = £3300
The formula is quite simple.
My work earn commission from £8K
Invoice Value £0 - £10,000 = 10%
£10,001 - £20,000. = 12.5%
£20,001 - £40,000. = 15%
£40,001 - £75,000. = 20%
£75,001.00. = 25%
So for example,
£10K (£10K - £8K, £2K * 10%)) = £200
£20K (£20K - £8K, £12K * 12.5%) = £1500
£30K (£22K * 15%) = £3300