Goal Seek Excel 2013
Understand Goal Seek in Excel 2013
At whatever point you make a recipe or capacity in Excel, you set up different parts together to compute a result. Goal Seek works in a contrary way: It gives you a chance, to begin with, the desired result, and it figures the input value that will give you that outcome. We’ll utilize a couple of cases to demonstrate to utilize Goal Seek.
To utilize Goal Seek (illustration 1):
Suppose you’re enlisted in a class. You as of now have a review of 65, and you require no less than a 70 to pass the class. Fortunately, you have one last task that may have the capacity to raise your normal. You can utilize Goal Seek to discover out what review you require on the last assignment to pass the class.
In the picture underneath, you can see that the evaluations on the initial four assignments are 58, 70, 72, and 60. Despite the fact that we don’t comprehend what the fifth grade will be, we can compose a recipe—or capacity—that figures the last grade.
For this situation, every task is weighted similarly, so we should simply normal each of the five evaluations by typing =AVERAGE(B2: B6). When we utilize Goal Seek, cell B6 will demonstrate to us the base review we’ll have to make that task
- Select the cell whose value you want to change. Whenever you use Goal Seek, you’ll need to select a cell that already contains a formula or function. In our example, we’ll select cell B7 because it contains the formula =AVERAGE(B2: B6).
- From the Data tab, click the What-If Analysis command, then select Goal Seek from the drop-down menu.
- A dialog box will appear with three fields:
- Set cell: This is the cell that will contain the desired result. In our example, cell B7 is already selected.
- To value: This is the desired result. In our example, we’ll enter 70 because we need to earn at least that to pass the class.
- By changing cell: This is the cell where Goal Seek will place its answer. In our example, we’ll select cell B6because we want to determine the grade we need to earn on the final assignment.
- When you’re done, click OK.
- The dialog box will tell you if it was able to find a solution. Click OK.
- The result will appear in the specified cell. In our example, we calculated that we will need to score at least a 90 on the final assignment to earn a passing grade.
To read more about Office Products visit WWW.OFFICE.COM/SETUP