
Reason: The constraints in your formula make you not find the input value to get your ideal formula outcome. Have you entered the right input for each of them? Read again the goal seek inputs, steps, and requirements parts of this tutorial to guide you Solution: Check again your formula cell, output target, and input cell inputs in the goal seek dialog box. Reason: You don’t give proper inputs in the goal seek dialog box. Here are three reasons which are probably the most possible ones and the solution for each of them. There are many things that can cause that to happen.
Goal Seek Not Working? Possible Reasons & SolutionsĬannot get the result you desire by using the goal seek feature? The goal seek feature seems to not run properly in your excel?
Just click OK in the dialog box after you get the input value to finish using goal seek After a while, it should give you the value in the input cell you gave in its dialog box.
Click the OK button in the Goal Seek dialog boxĭone! Goal Seek should begin to calculate the input value you want to get after you click its OK button. As with the formula cell, you can type the cell coordinate directly or just click the cell This input is the value you want to get from goal seek to get the output you want from the formula. In the “By Changing Cell” text box, input the formula input cell which value you want to optimize. In the “To Value” text box, input the output you want from the formula. To input it, type the cell coordinate or put your typing cursor in the text box and click the cell In the dialog box that shows up, input the cell with your formula in the “Set Cell” text box. Go to the Data tab, click the What-if Analysis dropdown button, and choose Goal Seek…. Make sure you have the cell with the formula, the cell with the input for the formula, and the output target Prepare the inputs you want to give to goal seek. Looking for a step-by-step guide to help you use the goal seek feature in excel? The one below should help you with that!