0
Goal Seek is used to obtain a value as part of a calculation that will result in your formula a particular result. As a simple example do the following:
In cell A1 type 10. In cell A2 type:
=A1+B1
You will initially get 10 in A2. Say you now wanted to find out what value you would put in B1 so that the formula in A2 gives a total of 16. Obviously you know that it would be 6. What you can do is go to the Tools menu and select Goal Seek. In the dialog box that comes up you will get 3 things to fill in.
In the Set Cell box, type A2
In the To Value box, type 16
In the By Changing Cell box type B1.
The result will be the appearance of 6 in cell B1. Obviously that is a simple example that you could work out in your head, but occasionally there will be cases where you want to find a value that is not so easy to work out. That is when you use Goal Seek.
Wiki User
∙ 14y ago
Wiki User
∙ 14y agoGoal Seek is used to obtain a value as part of a calculation that will result in your formula a particular result. As a simple example do the following:
In cell A1 type 10. In cell A2 type:
=A1+B1
You will initially get 10 in A2. Say you now wanted to find out what value you would put in B1 so that the formula in A2 gives a total of 16. Obviously you know that it would be 6. What you can do is go to the Tools menu and select Goal Seek. In the dialog box that comes up you will get 3 things to fill in.
In the Set Cell box, type A2
In the To Value box, type 16
In the By Changing Cell box type B1.
The result will be the appearance of 6 in cell B1. Obviously that is a simple example that you could work out in your head, but occasionally there will be cases where you want to find a value that is not so easy to work out. That is when you use Goal Seek.
Wiki User
∙ 12y agoIn computing, goal seeking is the ability to calculate backward to obtain an input that would result in a given output. This can also be called what-if analysis or back-solving. It can either be attempted through trial-and-erroror more logical means. Basic goal seeking functionality is built into most modern spreadsheetpackages such as microsoft-excel-2003.
Read more: goal-seeking
Wiki User
∙ 12y agoGoal seek is excel 2007 in data tab, whereas in excel 2003 you can find it in click tools menu then select data and then select goal seek.
Add your answer:
Earn +20 pts
Does excel 2010 have goal seek?
Yes. Under the data tab > what if analysis > goal seek
Where is the Goal Seek Command located?
In excel 2010 it can be found in the data tab > data tools > what if analysis > goal seek
What is value seek in Excel?
You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.
What ribbon is the goal seeking command on in Excel?
In Excel 2007, on the Data ribbon tab, click on What-If Analysis in the Data Tools group, and select Goal Seek. In older versions of Excel it is on the Tools menu.
In excel Goal Seek which and field represents the element of the formula that is a mystery?
to value
In Excel a what-if analysis in a cell containing the desired result called?
For one individual cell, it can be a Goal Seek.
What is one of excel's what-if analysis tools which provides a method to find a specific value for a cell by adjusting the value of one other cell?
Goal Seek! Good luck with your BI class!
Which tool in Excel should you use if you know the answer but you don't know the input value?
You would use Goal Seek.
Which tool in excel 2013 should you use if you know the correct answer but you don't know the input value that you need to get there?
Goal Seek.
Which of these is not a valid Excel analysis tool or function what if goal seek now function if statement?
Goal Seek is not a function or an analysis tool. It is a tool that is used to establish a value to be used for a formula. What If and the IF function can be used for analysis. The NOW function is a function but it is not an analysis tool.
What tool is used to create new input values when given a desired end result in Excel?
The Solver. You can also use Goal Seek to get a single value.
To determine the value of a cell on which the formula depends?
GOAL SEEKING -- You can use the Goal Seek facility.
