Use the MODULO function to get the remainder.
r = QTY % 12
Along with the quotient.
q = QTY / 12
(q * 26.00) + ( {lookup what the price is for "r" items} )
Beverly
On 10/17/08 9:17 AM, "WebDude" <[EMAIL PROTECTED]> wrote in whole or in
part:
> 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
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
