I am trying to create a spreadsheet to calculate our commissions, but I've hit a brick wall with this one.
The scheme is anything billed up to £10K is paid at 10%, the next £5K at 15%, the next £5K at 20%, the next 5K at 25% and finally anything above that at 30%. so as an example a billing of £35K would generate a commission of £7K, (£10K @ 10% = £1000 + £5K @ 15% = £750 + £5k @ 20% = £1000 + £5K @ 25% = £1250 + the remaining £10K @ 30% = £3000)
The ideal would be to do this in one function so I won't need any more than one cell to calculate this, I'm hoping there is some brilliant formula that can do this that I am not aware of!
Please help! Thanks in advance!
