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.
Cleve Schultz
Add your answer:
Earn +20 pts
To determine the value of a cell on which the formula depends?
GOAL SEEKING -- You can use the Goal Seek facility.
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
When did Sidney Excell die?
Sidney Excell died in 1990-12.
When was Sidney Excell born?
Sidney Excell was born on 1906-12-23.
When did Excell International School end?
Excell International School ended in 2010.
When was Excell International School created?
Excell International School was created in 1851.
What is the goal NGOs seek?
The goal of most NGOs is to address humanitarian needs.
When did E. O. Excell die?
E. O. Excell died on 1921-06-10.
When was E. O. Excell born?
E. O. Excell was born on 1851-12-13.
One goal that progressives did not seek was?
Ban on strikes
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.
