Calculation of incremental pricing

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