Having a hard time wrapping my head around this one. Any help would be appreciated. Let's say we have bottles of perfume for sale. For shipping, we can fit 12 bottles into a box. Each box is sent separately via a courrier. The courrier charges x amount for each box plus weight. To make a long story shorter, in this scenario, we have different charges for quantities of bottles within a box. So, for a specific zone, we charge like so... Quantity Price 1 $14.50 2 $15.50 3 $16.50 4 $18.50 5 $18.75 6 $19.00 7 $20.00 8 $21.00 9 $22.00 10 $23.00 11 $25.00 12 $26.00 Now the problem is the thirteenth bottle. We need to charge 26.00 + 14.50. 14th bottle would be 26.00 + 15.50. 15th bottle would be 26.00 + 16.50, etc. And to continue following this format... 24 bottles would be 26.00 + 26.00 25 bottles would be 26.00 + 26.00 + 14.50 26 bottles would be 26.00 + 26.00 + 15.50 27 bottles would be 26.00 + 26.00 + 16.50, etc. There is a formula in there somehow, but I am having a devil of a time trying to figure it out. Any help would be appreciated. Thanks!
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
