Excel Solver either keeps changing the answer or gives the same wrong answer.

Re: `` I am getting a repeated output of 7.10 after playing around with my variable cell's initial value. Before that, Solver kept returning different values (ranging from low to high 7's) ``

It would help us help you if you gave some examples of you "played around" with the initial values.


Re: `` [...] I've also tried using the same initial values to the variable cells as used in my course but that doesn't help.

I presume you mean


I get consistent results with those initial values in B11:C12. In fact, they are the same result as when initial B11:C12 are empty.

/r/excel Thread