How To Use Excel Goal Seek
Set cell the formula of the result to value the desired result of the formula by changing cell the value you want to adjust now let s apply them in a real life scenario.
How to use excel goal seek. In excel for mac 2011. The goal seek function part of excel s what if analysis tool set allows the user to use the desired result of a formula to find the possible input value necessary to achieve that result. Use goal seek to find the input value that produces a formula result of 25. Dan s score needs to be matching the overall average which is b10. How to use goal seek in excel.
Set cell the reference to the cell containing the formula b5. To display the insurance rate as a percentage appropriate for this example click the home tab at the top of excel click cell b3 then press ctrl shift. From the data tab select the what if analysis button. The goal seek tool is simple to use. Excel returns an approximate solution.
Click on what if analysis drop down menu click on goal seek in the goal seek dialog box select b6 in the set cell enter 25000 in the to value. Use goal seek again. To value the formula result you are trying to achieve 1000. In excel 2016 for mac. In the set cell box enter the reference for the cell that contains the formula that you want to resolve.
Goal seek will run and display the insurance rate in b3 based on the payment amount in b4. Other commands in the what if analysis tool set are the scenario manager and the ability to create data tables. Excel returns a more precise solution. Select goal seek from the drop down menu. The default value is 0 001.
Goal seek function finds a solution and shows with goal seek status. Press ok and you will get dan s score. In the example goal seek determined that the interest rate is 7 02. There are three parameters you should know about. Steps to using goal seek create your formula within your spreadsheet select the cell that you want to change to output to from the data ribbon select what if analysis and select goal seek shortcut key alt a w g.