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

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

​

https://preview.redd.it/60c4qui46kwa1.png?width=386&format=png&auto=webp&v=enabled&s=250b51e629d58b33261f9ab9d743164e4bc5bfd8

​

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
Previous
Next

Recently removed from /r/excel

How do you get rid of the blasted format painter icon that obscures text - Excel/Mac 16.72 - Microsoft 365 What’s the easiest way to share an excel document with Reddit? How do I set a character max and format? Calculate total number of years months and days from already calculated set of individual results displayed as years months and days. Dynamic Scheduling Based on Rotation and Start Day Is there a way to turn my date range in text form to a two-column number form date range? Is there any way to freeze the top row by default or otherwise save the state of frozen cells? Why is my rounding bugging? Vlookup issue with value that exists completing the excel exposure Complicated MOD function that possibly might just be algebra.. Comparing two workbooks for differences Microsoft Money for Excel released today How do I insert a number of blank rows between every row of data, and then copy each row down? Copy data into new sheet with a break after every nth row or copy formula into every cell with breaks every nth row

More Random Comments

People of Reddit, When is one time you have felt genuine, 100% fear? Our nightmares = their fetishes Our nightmares = their fetishes what’s the difference between what American people do and what European people do? For My Barbour Boys France Tried Soaking the Rich. It Didn’t Go Well. NXT is fantastic and probably puts on a fantastic wrestling show every week. Here's why I don't watch it... Do I qualify for lemon law? Someone is currently streaming themself getting 2k Telos on their friend's account. Why are suicidal people still alive? If we are for fat people, we aren’t for eugenics Why do people brag about not reading? Here's another effort to normalize pit bull behavior What's the most useless thing you've learned in school that actually came in handy one day? I used to be an alcoholic, and the biggest drinker of my peers, now I'm one month sober and intend on staying that way, but I'm now the only non-drinker of my friends