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