The Goal Seek function in Excel allows you to adjust an input value in a formula to determine a desired outcome. This What-If Analysis tool is ideal for situations where you know the outcome you want, but aren’t sure of the values needed to reach that o

See the screenshot below and follow the steps listed to use the Goal Seek Excel tool. Steps to Use Goal Seek Excel: Put the cursor on the cell that contains the output you want to change (revenue) On the Data ribbon, select What-if-analysis, then select G

Use Goal Seek to determine the interest rate. Do one of the following: In Excel 2016 for Mac: On the Data tab, click What-If Analysis, and then click Goal Seek. In Excel for Mac 2011: On the Data tab, in the Data Tools group, click What-If Analysis, and t