Forum Discussion
Solved
Looking for a way/formula to calculate a number based on a selection of specific products
Hello, We are working on a pretty odd way to give discount to our client based on wich products they purchase combined to each other. I would like to make a verry simple excel using checkboxes ...
See the attached sample workbook.
How about other combinations? For example:
A + C + G + B = -5% ?
A + B + C + D + E = 0%?
Etc.
- No, these are unique combinations. products are not interchangable.
See the attached sample workbook.
