Subtotal based discounts
 

Formlula for discount:

=IF(J4640,J46*0.2,IF(J4630,J46*0.15,IF(J4620,J4 6*0.1,IF(J4610,J46*0.05,0))))

Formula for shipping:

=IF((J46-J47)50,"FREE",10)

Formula for total price:

=SUM(J48,J46)-J47


--
C01d
------------------------------------------------------------------------
C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422
View this thread: http://www.excelforum.com/showthread...hreadid=548286

Subtotal based discounts
 

ianonline:

For
J46 containing the subtotal
J47 containing the discount amount
J48 containing the shipping amount
J49 containing the total

Here are some options

The discount:
J47: =CHOOSE(MIN(FLOOR(J46/10,1),4)+1,0%,5%,10%,15%,20%)*J46
or
J47: =(MIN(FLOOR(J46/10,1),4)*5%)*J46
or
J47: =(MIN(INT(J46/10),4)*5%)*J46

-----------
The shipping:
J48: =IF(J46-J4750,"FREE",15)

-----------
The total:
J49: =J46-J47+N(J48)

Can you work with that?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=548286