What-if analysis defined

What-if analysis is the process of changing the values in various input cells to see how they might affect the output.

Goal seek analysis

Goal seek analysis is a form of what-if analysis that determines the needed input or actions to be taken (or assumed) to reach a desired outcome, output, or result. It calculates backward with the desired result to understand the potential paths needed to achieve the output.

Goal seek analysis examples