98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Goal seek and solver
Goal seek and solver
Resolved · Low Priority · Version 2003
Mon 19 Jan 2009, 17:07Delegate Jon said...
Jon has attended:
Excel Advanced course
Goal seek and solver
Pls explain the main differences between goal seeker and solver
Mon 2 Feb 2009, 13:25Trainer Carlos said...
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
Mon 9 Feb 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Convert Text to Columns in Excel 2010If you have a cell in your Excel spreadsheet that contains a lot of text and you want to divide it into separate columns, this can only be done if there is a logical character which separates the text, for example, a comma. |
