Forum Discussion
Excel Solver
I am wanting to use Excel Solver to find find the weights, standard deviation, and variance at a specific return%. When I go and use solver and click solve the parts in yellow beside the target return % does not change. Can anyone help me fix it? I need it for a homework assignment to work.
5 Replies
There must be something missing - all other weights are set to 0, so all weighted calculations will return 0 regardless of the values in Q3:Z3.
- I went and changed the weights in q3:z3 to having nothing in them and I am still not able to have any of the information changed.
Of course not - all results will still be 0.
