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