All combinations to a certain goal URGENT GRADUATION ISSUE

%3CLINGO-SUB%20id%3D%22lingo-sub-1390367%22%20slang%3D%22en-US%22%3EAll%20combinations%20to%20a%20certain%20goal%20URGENT%20GRADUATION%20ISSUE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1390367%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20friends%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20urgent%20excel%20question.%20For%20my%20graduation%20I%20want%20to%20calculate%20al%20combinations%20of%20certain%20variables%20to%20a%20revenue%20goal.%20So%20for%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20goal%20is%20a%20revenue%20of%2010.000%20and%20I%20sell%205%20products%20with%20the%20following%20margins%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProduct%201%20%3D%20500%2C-%3C%2FP%3E%3CP%3EProduct%202%20%3D%20800%2C-%3C%2FP%3E%3CP%3EProduct%203%20%3D%20700%2C-%3C%2FP%3E%3CP%3EProduct%204%20%3D%20400%2C-%3C%2FP%3E%3CP%3EProduct%205%20%3D%20200%2C-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20know%20all%20combinations%20of%20the%20above%20products%20to%20get%20to%20my%20target%20of%2010.000%2C%20so%20for%20example%3C%2FP%3E%3CP%3E1%20*%20product%201%20%2B%2010%20*%20product%202%20%2B%203%20*%20product%207%3C%2FP%3E%3CP%3E3%20*%20product%204%20%2B%206%20*%20product%205%20%2B%201%20*%20product%201%20%2B%2011%20*%20product%203%3C%2FP%3E%3CP%3E13%20*%20product%202%3C%2FP%3E%3CP%3EAnd%20so%20on%2C%20just%20all%20different%20combinations%20there%20are%20to%20get%20to%20the%20revenue%20of%2010.000.%20I%20need%20this%20for%20my%20graduation%20project!%20Is%20there%20a%20way%20to%20do%20this%20by%20giving%20the%20variables.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20someone%20can%20help%20me!%26nbsp%3BMy%20gratitude%20will%20be%20great!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%20Jacob%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1390367%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Dear friends,

 

I have an urgent excel question. For my graduation I want to calculate al combinations of certain variables to a revenue goal. So for example:

 

The goal is a revenue of 10.000 and I sell 5 products with the following margins:

 

Product 1 = 500,-

Product 2 = 800,-

Product 3 = 700,-

Product 4 = 400,-

Product 5 = 200,-

 

I want to know all combinations of the above products to get to my target of 10.000, so for example

1 * product 1 + 10 * product 2 + 3 * product 7

3 * product 4 + 6 * product 5 + 1 * product 1 + 11 * product 3

13 * product 2

And so on, just all different combinations there are to get to the revenue of 10.000. I need this for my graduation project! Is there a way to do this by giving the variables. 

 

I hope someone can help me! My gratitude will be great!

 

Kind regards, Jacob

0 Replies