Goal seek vista

If you want to accept more than one input value, for example, both the loan amount and the monthly payment amount for a loan, use the Solver add-in. Finally, format the target cell B3 so that it displays the result as a percentage.

Follow one of these steps:. Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve?

Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Below we have the accuracy data of the employee from Monday to Thursday with an average accuracy of For this, follow the below steps:.

We can choose any name to define this. Step 3: As per syntax, we will select the Range cell which contains the current average to be fed. Here that cell is C8. Step 4: Now select Goal Seek function and as per syntax, select the target value which we need to achieve.

Step 5: Now, at last, select the range of that cell, where we need to see the required accuracy to be achieved. Here that cell is C6 with cell reference to Friday. Step 6: Now once done, we will compile the code and run it. We will see cell C6 has the Changing Cell value as In this example, we have data of Turn Around Time TAT or time to complete the activity of some employee of a team who performs the same task every day.

The target time is set for completing that activity is 50 Mins. And we need to find how much time each employee needs to take to maintain the average completion time as 50 Mins or less.

So to find out the return, the person uses the FV function procedure of calculation is shown in the above figure. He wants to find the interest rate which will help him to attain the desired return.

This has been a guide to a Goal Seek in Excel. Here we discuss its uses and how to use Goal Seek in Excel with excel examples and downloadable excel templates. You may also look at these useful functions in Excel —. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password?

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy. Download Goal Seek Excel Template. Popular Course in this category.