Goal Seek
- GoalSeek is a way of setting up any number of
Goalseeks via GoalSeek functions in the workbook,
that are then calculated each time a 'Full Calculate'
of the workbook is carried out.
- The GoalSeeks can be scheduled in any order,
useful if the result of one GoalSeek affects
subsequent GoalSeek inputs.
- No need for any VBA - the automation takes place
within Business Functions Full Calculate menu
option
- GoalSeek functions, just like any other worksheet
functions, can accept cell references for all their
inputs, not just values.
|