Excell Calculations

I'm having a problem getting excell to calculate a formula for me. (Maybe I'm using the incorrect formula since I'm not familiar with formulas in excel)

I'm trying to create a formula which will render a different price for a product based on the quantity ordered.

For example, 100-
8x10 prints are not $.80 each. The actual total for 100– 8x10’s is
$109.36.
We add the 1st print price
($3.07) to the price of 9 duplicates at $2.41 plus 10 prints at
$1.55 plus 30 prints at $.97 plus 50 prints at $.80 to arrive at the
total of $109.36.

I'm wanting to create a table of print sizes with the associated quantity discounts in separate columns to the right of the quantity values.
If anyone is skilled with excel formulas and could help it would be greatly appreciated.
Thanks.
Kevin

It's hard to understand by just reading this. Attach the spreadsheet and I'll take a look at it.

So, you have a graduated pricing scheme, but you charge the same price for the first nine regardless of whether the quantity ordered is nine or 100?

Do you have a formula right now? If you do, post it. What kind of error are you receiving?

I have attached the labs pricing formula. The system wouldn't allow an Excel attanchment so I saved excel file as tab delimited .txt file

What do the symbols preceding some of the sizes denote?

The symbols are simply related to type of photo paper prints are printed on. They do not affect the pricing.

Okay, the simplest way would be to use a nested IF statement--

=IF(K2=1,2.14,IF(K2<11,(((K2-1)1.52)+2.14),IF(K2<21,(((K2-10).93)+15.82)...

It may not be the most elegant solution, but it should suffice. If the program doesn't want to accept the equation (provided syntax is correct, I have no idea if the above is good or not, I pulled it off the top of my skull) then try holding down the shift key and hitting enter.