Course contents · What-if analysis

Goal Seek

Open the practice in the trainer →

If you know the result you want but not the input value that produces it, use Goal Seek: Data → What-If Analysis → Goal Seek.

Example from the manual: the PMT formula gives a payment higher than you can afford. Goal Seek finds the loan term that makes the payment affordable.

Excel finds the value by iteration, so the result may be fractional — round it.

Tasks in the trainer

  1. In D5 calculate the total of all loan payments (payment × term).
  2. In D8 — the contribution margin per unit (price − variable cost).
  3. In D11 calculate the break-even point with a formula (fixed costs / margin per unit), then compare it with Goal Seek.

Solve the tasks in the trainer →

Check yourself

  1. Can the changing cell in Goal Seek contain a formula?
  2. How is Goal Seek different from a data table?