Use the Goal Seek feature to find the required input for a desired output

Use the Goal Seek feature to find the required input for a desired output

Step 1: Set up a formula in a cell that references the input cell.

Step 2: Click on the “Data” tab and choose “What-If Analysis,” then “Goal Seek.”

Step 3: Define the “Set Cell” (formula cell), “To Value” (desired output), and “By Changing Cell” (input cell).

Step 4: Click “OK” to run Goal Seek and find the required input value.

For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com