View Categories

How can I use the Goal Seek function in Excel?

< 1 min read

Here is a list of steps you can take to use the Goal Seek function in Excel:

  1. Under the Data tab, select what-if analysis, and then select goal seek

  2. You will be asked to indicate which cell contains the formula, the target value, and the changing cell

  3. Adjust the changing cell so the resulting value of the formula matches the target value

Powered by BetterDocs