|
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.
|