MS Excel Goal Seek
HOME Goal Seek is used to get a particular result when you are not too sure of the starting value. For example, if the answer is 56, and the first number is 8, what is the second number? Is it 8 multiplied by 7 or 8 multiplied by 6? You can use Goal Seek to find out. We will try that example to get you started, and then have go at a more practical example. Create the following Excel spreadsheet: In the spreadsheet above, we know that we want to multiply the number in B1 by the number in B2. The number in cell B2 is the one we are not too sure of. The answer is going in cell B3. Our answer is wrong at the moment, because we has a goal of 56. To use Goal Seek to get the answer, try the following: From the Excel menu bar, click on Data. Locate the Data Tools panel and then What if Analysis item. From the What if Analysis menu, select Goal Seek . The following dialogue box appears: The first thin...