Hi,
Hoping someone out there can help. This is my first post so i hope i get it right with what i am trying to say and effectively do...
I am complying an order form for shoes. There are multiple colours per style that you can order. i am trying to introduce an incentive for the less popular colours where if you select these particlar colours, you will receive 3% off the total price of that style; but only if you include these colours, if not, then the price remains as normal.
i have attached an example of the order form... There is a summary page where everything is tallied and the total amounts shown, and the order page. The highlighted yellow cells on the order page are the incentive colours, and if you select sizes of these colours you will get the discount. (this crosses over all months)
I hope i am making sense. This formula is way above my knowledge of excel and so i have no idea what kind of formula i am even needing.
Basically what i think i need the formula to say is:
=IF(G28,H28,I28,G28,K28,L28>=1, and
=IF(G44,H44,I44,G44,K44,L44>=1, then apply the 3% dicount to total style
=Summary!M19/.03
All of these cells alreadu have formulas in, so not sure if that is an issue. let me know if you need more information
Can someone please help?
Bookmarks