Goal Seek is a process of calculating a value by performing what-if analysis on a given set of values. For our purposes, Excel's Goal Seek feature lets you adjust a value used in a formula to achieve a specific goal. Or, put another way, Goal Seek determines input values needed to achieve a specific goal.
Use Goal Seek in MS Excel, do the following:-
1. Open the blank spreadsheet and enter some data and calculate the result.
2. Put the cursor on the cell that contains the output you want to change.
3. On the Data ribbon, select What-if-analysis, then select Goal Seek.
4. When the dialog box appears make “Set cell” eg. (A10)
5. Set “To value” equal to the output you want to achieve (type the number in)
6. Set “By changing cell” equal to the assumption you want to solve for eg. cell E4
7. Press OK.
0 Comments:
Post a Comment