Calculating % of cost with different tiers

Hi

We use an agency at work and they have a tiered pricing structure.
So:

All monthly spend below £7,500 – 11%
All spend between £7,501 and £15,000 – 10%
All spend between £15,001 and £25,000 – 9%
Spend above £25,000 – 8%

So if we spend £10,000 it would be (£7,500 x 11%) £825 + (£2,500 x 10%) £250 = 1,075.

I'm trying to work out a formula that will just calculate fees if we change the spend figure.

I've had a look at http://www.excelforum.com/excel-gene...nt-levels.html but couldn't quite figure out a way to get this to work.

Any help you can get would be really appreciated.

Let me know if you need anything else.

Thank you!
Kane

This should work. Just input the total where prompted.

Excellent. Thank you so much!