98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Goal seek
Goal seek
Resolved · Low Priority · Version 2003
RE: goal seek
Hello Maria
Thank you for your question and welcome to the forum.
The reason you would use Goal Seek is to get Excel to set the result of a formula to a specific amount, by asking it to change one of the inputs into that formula.
For example, if I multiply cells A1, A2 and A3 together to get a result in cell A4, so
A4 =A1*A2*A3
I can select cell A4 and go to Goal Seek (Tools - Goal Seek) and say I want A4 (target cell) set to 500 by changing cell A1 (or it could be A2 or A3).
If Excel can find a solution for me, it will change the result of the formula in A4 to 500 by changing the value in the cell I've specified (A1).
I hope this helps.
Amanda
Thu 18 Dec 2008: 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 a column into row quickly in Excel 2010Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa. |