Calculation of incremental pricing

Hi, I have a question that relates to calculating pricing where the price per unit rises in incremental steps as the number of units increases. i.e.

The price might be $0.75 per unit for 0-200 then $0.50 for 201-500 $0.35 for 501-1000 etc

I'm trying to work out how to enter a number of units ie 300 and by referring to a table of prices for each range of unit numbers the formula calculate that 200 will be at 0.75 and 100 will be at 0.50 and calculate a total cost of $250

Any help would be appreciated.

Look here

Using this method for your specific problem you'd get a formula like

=SUMPRODUCT(--(A1>{0,200,500}),A1-{0,200,500},{0.75,-0.25,-0.15})

where A1 contains total number of units

Thanks I really appreciate that. This is the formula I ended up with and it works perfectly!

=SUMPRODUCT(--(B29>$C$20:$Q$20), (B29-$C$20:$Q$20), $C$23:$Q$23)

I am trying to figure out how to find the total cost based on price range
If there is just 1 then it would be 69 but say there are 2. What would the cost be for 2-9 units and so on.

1-9 69.00
10-24 9.90
25-39 7.16
40-99 6.73
100-199 6.00
200-299 5.50
300-399 4.19
400-499 3.63
500-749 3.29
750-999 2.84
1000-1499 2.61
1500-2999 2.39
3000-4999 2.15
5000-9999 2.05
10000+ 1.98