Hello Forum,
I am trying to create a formula that calculate discount rate of a pack, if customer pass threshold criteria from each product.
The tricky part is that each product has different nature and packs units can not be summed into one.
I wrote clear instruction inside the excel,,, this is a tough one.....
Cheers
Swiss Excel
Last edited by SwissExcel; 11-11-2015 at 03:32 PM.
Edit: discount table must be sorted by product code small to large
Please Login or Register to view this content.
Last edited by protonLeah; 11-11-2015 at 05:51 PM.
Ben Van Johnson
Thank ProtonLeah for taking the time to replay....I know its a tough one...
Your formula is close, but not exactly what I am looking.
the thing is the discount are based on overall purchase packs, not individually
Discount provided if:
1. Customer meet units target of each product separately (Column. D,E,F)
AND
2. Customer meet target for pack
(I.e - Customer need to buy 100 units of product 1, 200 units of product 2 and 3000 of product 3. only when buying all three products and their ratio - discount is given)
Do you think you can help on this one...???
Sorry, I don't think I can help further. There is nothing in the workbook relating units to packs. You only give unites sold and the table is based on units not packs.
Hello -
Pack name is in column C (there are two type of packs).
I am adding a reputation, but keeping the thread open. in case you do get to have another look - this would be highly appreciated.
Regards
Swiss Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks