Goal Seek

Goal Seek is a what-if analysis tool that finds the value of an input cell so that a formula reaches a desired result. It solves a one-unknown problem by successive trials. It suits questions such as: what volume must be reached to get this result?

Example

Data > What-If Analysis > Goal Seek: bring the Profit cell to 10,000 by changing the Volume cell.

Related concepts

The whole glossary