Modeling

[mcervino1]

Good Morning,

Is there a formula or function in excel that would allow me to model a set a variable inputs to calculate a set output?

For example

10 5 1 12 49 44
20 10 2 24 1 63
30 15 3 36 17 10
40 20 4 48 41 83
50 25 5 60 14 46
60 30 6 72 30 3


Say the set out put is 500 for the sum of Column 1,2,3,4,5,6 but i need to correct set of number in each column to get the set output.

Thoughts?

Thanks

[MrShorty]

Short but useless answer to your question: Yes, there is a formula/function (or some combination of formulas/functions) that should allow you to model your problem. Beyond that, I don't see how to give you a specific answer, because I cannot understand exactly what you are doing to model this data.

Perhaps this question to spur the discussion on: What do you mean that you want to sum columns 1 through 6 and come up with 500? Are you trying to find which combination of values (one from each column) should add to 500? Or maybe some combination of the first row of values should add up to 500 (500=ax1+bx2+cx3+dx4+ex5+fx6+g)? Or perhaps any combination of 6 numbers in the table to add up to 500?

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.