Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to calculate shipping costs based on subtotal | Excel Worksheet Functions | |||
subtotal based on two conditions | Excel Discussion (Misc queries) | |||
SUBTOTAL - TJ | Excel Worksheet Functions | |||
I need to subtotal based on an if | Excel Worksheet Functions | |||
subtotal a range of cells on a different worksheet | Excel Worksheet Functions |