Quote:
Originally Posted by classhandicapper
I must have solver installed already because as I change the values in those cells, the ROI and Win% changes and the spreadsheet reacts in a way that makes sense.
But I don't know exactly what I am asking when I change those numbers.
Let's say I put a "1" in cell G2, what am I asking?
If I put a 99 in there I get the same result.
What if I put a "1" in G2 and H2?
What if I put a "1" in G2 and G3?
|
I suspect you don't have it installed. The sheet would react that way whether you have the Solver add-in installed or not. If you go to the File tab > Options > Add-ins you should see 'Active Application Add-ins'. If Solver isn't there go to Manage Excel Add-Ins and place a check mark next to Solver Add-in. Now you'll see it show up as an option on the ribbon at the top (Data tab). The key to the sheet as an example is that the way it is setup is what allows solver to actually help you find the values. If you don't run it then you'd have to sit there manually trying various values for a very long time.