Forum Discussion
Corina Solis
Jul 28, 2017Copper Contributor
Need Excel formula for finding a Minimum input
I have a data set with a few columns. The first is static data, and the next columns are formulas based on: the corresponding value from the first column, a single input value (that is the same f...
SergeiBaklan
Jul 29, 2017Diamond Contributor
HI Corina,
Yes, result of Goal Seek is very depends on your initial guess if you have multiple answers. I'm not sure if direct solution for your case exists, it will be interesting to see if someone suggests.
As a workaround, if you know approximately the range of possible input values and it's not too big you could try Data Table from What-if Analysis. Depends on nature of your input numbers you may receive the answer within the data table, or at least it'll be easier to play with variants modifying input number(s) in formed data table.
But all that just guesses, without playing with figures it's hard to be concrete - have not a much of experience with these tools.