Complete Workflow

Create Model

↓

Create Formula Result

↓

Open Goal Seek

↓

Set Cell

↓

Enter To Value

↓

Select Changing Cell

↓

Solve

↓

Review Result

Important Points

  • Goal Seek changes one input cell at a time.
  • The changing cell must affect the result cell.
  • The result cell should normally contain a formula.
  • Goal Seek provides a solution based on the model you create.
  • Always review whether the result makes business sense.

Practice

Create three Goal Seek analyses:

  1. Target Profit
  2. Target Quantity
  3. Target EMI
PreviousNext