Quoting Formula

I am trying to come up with a formula to make a simple quoting program. I can't figure this out.

................X...............Y............Z
2"............. #...........Blank......Blank
3 ........... Blank........Blank......Blank
4
5
6


What I am looking to do is have a minimum price up to a point. So if they buy one 2" X they will be charged $15. However if they bought two, I would charge them $15 for the first and a flat rate of $10 each after this. My chart goes past 6 up to 24. At a certain point that baseline ($15) charge goes up to $40. Any ideas?

QUP QUP.xlsx

Here is the attachment. I want to have a minimum price of a set amount. After that initial 1 sold, I'd like the program to add an additional price to each one.

QUP QUP.xlsxWhat does 150#, 300#, #600 represent?
These numbers are just different pressure ratings for material

The values that are typed in the blank cells, what do they represent?
These represent the quantity of parts they would purchase

You want to perform a calculation, where does the formula/result go?
I]It doesn't matter where[/I]

You mentioned you were trying to come up with the formula, can you show us what you are working on and explain where you are stuck?
So far I have this: =IF(SUM(D9:R14)>1,(SUM(D9:R14)*10)+5,15) which gives me the number I am looking for. However I want it to work at different minimum rates. This works for OD" 2"-5". I want a different minimum cost on a different set, say 6"-8".

Can you provide some results by calculating them manually, so we have some values to go by?
Purchasing 1 item in the 2" category from 150#-600# would be:
QTY: 1 = $15
QTY: 2 = $15 + $10
QTY: 3 to Inf = $15 + 10 + 10 + 10 + ....N


As a note on your formatting, using the Merge and Center function can cause problems with formulas sometimes. You can expand the height and width of the columns to achieve the same looking result, without having to merge and center.[/QUOTE]