0
Set Cell is used to specify a cell in the worksheet that you want to have a particular value in when the process is finished, by changing a value in another cell. The cell specified in Set Cell will always have a formula in it.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
Excel function that allows you to set the value in a single cell in a worksheet?
You can use a facility called Goal Seek to try to establish a value in one cell that will produce a specific result for a formula in another cell.
What box in the Goal Seek dialog box contains the cell address that displays desired results?
That depends what you mean by the desired results. The "Set Cell" refers to the cell that has a formula and will show the result of a calculation. If that is the cell you mean by desired results, and most likely it is, then it is the "Set Cell" box. The "By Changing" defines which cell has a value in it that can be changed to give a particular result for the formula. So if you mean the desired result being finding which value makes the formula give you the total you want, then it is the "By Changing" box.
What is Goal Seek in Microsoft Excel and how do you use it?
Goal seek allows you to establish a value to be used in a formula so that formula makes a certain total. As a very simple example, suppose you want to find out what number added to 10 will give you 16. Obviously it is 6. You can use Goal Seek to get this for you. What you would do is this. We will leave cell A1 blank, as it is the cell that we want to use to get the 6. Into cell A2 we put the following formula:=A1+10Now we want use Goal Seek to set the value of A1 to 6, so that the formula in A2 gives us 16. Our "Goal" is the 16. Go to the Tools Menu and pick Goal Seek. A dialog box comes up looking for 3 things. For Set Cell put in A2. For To Value put in 16. For By Changing Cell put in A1. Then click OK. It then tries to find a value for A1 that will set the result of the formula in A2 to 16. Very quickly it will come up with 6.That is a very simple and obvious result, which demonstrates what it is for. Often the value you are trying to find to use in the formula won't be as obvious as the 6 was in this example. That is when Goal Seek becomes really useful.Remember that the formula must refer to the cell that you are trying to find a value for and you are putting in a result that you want the formula to reach. You just have to be careful about which things to put into the 3 parts of the dialog box. Set Cell is always the one with the formula. To Value is the result that you want the formula to reach. By Changing Cell is a cell that is referenced in the formula and for which you are trying to establish a value for.
What is the difference between Goal Seek and Solver in Microsoft Excel?
Solver can solve problems by enabling a target cell to achieve some goal. This goal may be to minimse, maximise, or achieve some target value. It solves the problem by adjusting a number of input cells according to a set of criteria or constraints which are defined by the user.Goal Seek is a simpler and more limited facility, which enables you to get a value for a target cell by adjusting just a single cell and does not allow you to have criteria or constraints.
What is goal seek in excell?
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.
What is the goal of the replication?
To ensure that every cell has a complete set of identical DNA
What is the definition of goal seek in Excel?
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.
What does don't bunt aim out of the ballpark mean?
to set a goal
What does it mean when people say that state a goal that would enhance your social life?
Set a goal like making new friends.
In Excel is Goal Seek usually a faster approach to reach desired data results than a what-if analysis?
They are not really for the same thing. Goal Seek is used to find a specific value that makes a formula give a particular result. It gives just one single result. If you have a formula that you need to give a particular result and a value for another cell used by that formula needs to be changed to get that result, then you use Goal Seek to obtain that value. Goal Seek is used to look for a single result rather than to give many results. What-If Analysis has a much broader purpose. It is designed to see what results you get when you use different values for the same set of formulas. It could be doing things like seeing how much profit you can make by paying different pay rates and using different amounts of staff and selling different amounts of products at different prices. So it can be used with many values and many formulas. Goal Seek can be used as part of What-If Analysis.
How do you setup personal goal?
To set up a personal goal you must simply set yourself a realistic goal for a certain date. Then you must work towards that goal.
Is a physical goal?
A physical goal is a goal that you set for yourself to be more active and healthy. For example, "Sue" set a goal to run 5 miles everyday. I hope that helped!
