Jon has attended:
Excel Advanced course
Goal seek and solver
Pls explain the main differences between goal seeker and solver
RE: goal seek and solver
Hi Jon
The main difference between the two is:
Goal seek allows you to achieve a known result by changing only ONE variable in the equation. eg:
(A3+A4) * A5/A6 = 375
If the answer is changed to 496 how will it change the value of cell A4
In Solver the same premise applies however you can change multiple cell values and even put in criteria
Hope this helps
Carlos