Hi

I'm trying to locate a formula that can calculate what I have to charge based on the below tier structu

Items Cost
1-1250 £1.50
1251-1500 £1.25
1501-1750 £1.00
1750+ £0.75

If a figure of 1550 was placed into a cell then the price I have to charge based on the above tiered structure should be £2237.50

i.e.

First 1250 items equals £1875.00
Next 250 items equals 312.50
Next 50 items equals £50.00

does such formula exist?

Thanks, in advance, for any assistance that can be provided.