Tiered Pricing Help!

I'm currently trying to work out how to calculate a tiered pricing fee structure of the below;

Amount = £100,000,000

First £250,000 = Fee of 0.85%
Next £250,000 = Fee of 0.70%
Next £500,000 = Fee of 0.60%
Next £1,500,000 = Fee of 0.45%
Next £2,500,000 = Fee of 0.25%
Next £5,000,000 = Fee of 0.15%
Above £10,000,000 = Fee of 0.10%

Any help would be appreciated!

Thanks
Ashley

Thanks both for your help - I've attached the hopefully helpful spreadsheet with a couple of examples / desired results.

Thanks
Ashley

Hi shg,

unless i'm missing something, the results differ to those I had completed manually?

Thanks

Hi,
Try this one.

Thanks shg,

The figures are correct however I cannot input the formula, would you mind creating a spreadsheet I can download?

Also, if I wanted to enter a random number is there anyway to factor additional 'donation amounts' ?

Thanks

however I cannot input the formula .....

Why not ???

See sample in attached, highlighted

=SUMPRODUCT((I7 > $G$8:$G$14) * (I7 -$G$8:$G$14) *$H$8:$H$14)

Thank you so much John!

Great work

You're welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Thanks again John,

if I wanted to edit the fee's / tiers, how would I go about doing so?

For example;
First £150,000 = Fee of 1.00%
£500,000 = Fee of 0.75%
£1,000,000 = Fee of 0.40%
£5,000,000 = Fee of 0.20%
£10,000,000 = Fee of 0.10%
Above £10,000,000 = Fee of 0.05%

Thanks!

Ashley fwiw when I had a similar query I found this article useful.

Link

Hope this helps,

Snook