| Goal Seek allows you to perform 'What-If'
analysis on a cell with a formula, (i.e. " What
value do I need in this cell to make the formula
show x"). Via the 'Set-up' dialog below, you
set a cell you want to set to a value (must have
a formula), by changing the value of another
cell. Goal Seek tells you what you have to put
in the 'changing' cell to get the desired value,
or it's closest value if it cannot match your
request exactly, in the 'target' cell.
There is also 'Step' and 'Pause' button for
multiple level what-ifs
It shows these values in the 'Results' dialog
shown at the very bottom of this section.
In our simple example we are taking a small
matrix and changing the value in A2 to arrive at
a value of 8.536 in A3. (A3 has the simple
formula =A1*A2 in it).
Set-up Dialog
Results Dialog
 |
