Q6. What is the difference between Goal Seek and Solver ?
N
Answers
Answered by
2
Answer:
Solver can solve formulas (or equations) which use several variables whereas Goal Seek can only be used with a single variable. Solver will allow you to vary the values in up to 200 cells whereas Goal Seek only allows you to vary the value in one cell
Explanation:
Answered by
43
Goal Seek determines what value needs to be in an input cell to achieve a desired result in a formula cell. Solver determines what values need to be in multiple input cells to achieve a desired result
Similar questions