How to Use Goal Seek in Excel
Backsolving for What-If Analysis
3 min readAug 5, 2021
Excel’s Goal Seek is a What-If Analysis feature that allows backsolving calculations. It’s useful in situations where you have a known output value but want to find the input that dictates it.
In the ribbon, it is found in Data (tab) > What-If Analysis (Forecast group) > Goal Seek.