SOLVED

Looking for a way/formula to calculate a number based on a selection of specific products

Copper Contributor

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 where you select the products and you are given the percentage discount you receive.

 

jonlaloux_0-1692350278959.png

 

The discount chart is as followed:

A + C + G = -5%

B + E + F + I = -5%

D + H + J + K = -5%

A + C + G + E = -7.5%

B + E + F + I + A = -7.5%

D + H + J + K + C= -7.5%

A + C + G + B + E + F + I = -12.5%

A + C + G + D + H + J + K = -12.5%

B + E + F + I + D + H + J + K = -12.5%

ALL PRODUCTS = -20%

 

Thanks in advance!

3 Replies

@jonlaloux 

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.
best response confirmed by jonlaloux (Copper Contributor)
Solution

@jonlaloux 

See the attached sample workbook.

1 best response

Accepted Solutions
best response confirmed by jonlaloux (Copper Contributor)