Excel will refuse to proceedĮxcel will attempt to reach the goal value that you put in. Should only contain a number or a value no formulas. Which cell can Excel change the value in order to get the desired result? That cell What is the value you wish to reach for this cell? Which cell has the result that you want? That cell should The Tools menu, select the Goal Seek option.Įxcel needs three things to find the targeted value. The following values and formula in the appropriate cells. You find the answer by using the Goal Seek. Instead of trying to find the answer by trial and error, Excel can find What the result should be but not what the value in a cell should be. In the following example, what should be the value in the A1 cell so that the A3 cell shows 500? You already know This option will help you find the missing value in a cell to attain Tools: target value, the scenario manager and the solver. Several analysis tools that can help you. You created your own decision-making model and now you want Excel to help you find the best solution for your situation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |