Nesting Algo: Find Formula for List & Target (520)

[Arkamis17]

Hey guys,

I'm searching a formula for this kind of situation :

We have a list of values (33,60,50,15,100) and a target (520). We want to know how many times each value can go in the target (close to) with those specifications :

- Maximum 2 different value at the time
- Minimum use of valuesI'm pretty sure, there is a formula out there that respond to our situation.
P.S.: Forgive my English speaking, it's not my primary language.

 

[mathman]

Your description of what you are looking for is very unclear. Give an example of what you are trying to describe.