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!
0 kommentar(er)
