Goal Seek
Goal Seek allows you to perform a special analysis on a formula wherein you specify the result in order to determine the value of an input parameter required to achieve the specified result.
As with most features, an illustrated example of Goal Seek will hopefully explain clearly how it works.
In the example below, we see a simple formula - it is for illustrative purposes only.
The Goal Seek function is invoked as shown below - after selecting the cell with the formula we wish to analyze.
The Goal Seek dialog box is opened with the Formula Cell prefilled with the selected cell. It reaminas for us to fill in the Target value and Variable cell fields. The Target value is the desired value of our formula and the Variable cell is the cell whose value we wish to adjust wit ha view to obtaining the desired value.
When we press OK to close the Goal Seek dialog box, a confirmation dialog opens to indicate that a value was found for the Variable cell that satisfied the
Our updated spreadsheet.
