I am trying to work out a formula for my below commission structure;

£0.00 - £5,000 generated = 0% commission

£5,000 - £10,000 = 15% commission

£10,000 - £15,000 = 17.5% commission

£15,000 - £20,000 = 20% commission

£20,000 - £25,000 = 22.5% commission

£25,000 + = 25% commission

(so, for example, if I were to generate £16,000 for the business, £5,000 would be non commission-able. The next £5,000 would give me £750.00 (15%). The following £5,000 would be £875.00 commission (17.5%) and the final £1,000 would be @ 20% so another £200). I would earn £750 + £875 + £200 (total of £1,825.00).

How would I put this all into one excel formula? Is there a way to do it so I can input the money I have generated into one cell and the commission is automatically generated into another?

Any help would be amazing!