SOLVED

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

Copper Contributor

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

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%

3 Replies

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

How about other combinations? For example:

A + C + G + B = -5% ?

A + B + C + D + E = 0%?

Etc.

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

No, these are unique combinations. products are not interchangable.
best response confirmed by jonlaloux (Copper Contributor)
Solution

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

See the attached sample workbook.

1 best response

Accepted Solutions
best response confirmed by jonlaloux (Copper Contributor)
Solution

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

See the attached sample workbook.