Sum Limit and marking wrote...
>Is there another way to do this by using the current price sturcture and not
>adding another column? Is there something in the current formula that I can
>add so it can calculate the pricing at 5,000 and 5,500?
....
>>>>"Sum Limit and marking" wrote:
>>>>>I have a price chart with the following information:
>>>>>
>>>>>Qty: 500 1000 2500 3500 5000
>>>>>Lot Price: 269 308 421 503 585
>>>>>Add'l qty: .14 .14 .09 .07 .055
....

If the table above were named Tbl and the cell into which you enter the
quantity ordered were named Qty, then you could try

=IF(Qty<INDEX(Tbl,1,1),INDEX(Tbl,2,1),MIN(HLOOKUP(Qty,Tbl,2)
+(Qty-HLOOKUP(Qty,Tbl,1))*HLOOKUP(Qty,Tbl,3),IF(Qty<MAX(INDEX(Tbl,1,0)),
INDEX(Tbl,2,MATCH(Qty,INDEX(Tbl,1,0))+1),1000000000000)))