Page 181 - Excel for Scientists and Engineers: Numerical Methods
P. 181
158 EXCEL: NUMERICAL METHODS
Enter a reference to the target cell in the Set Cell box (the cell reference will
appear there if you selected that cell before choosing Goal Seek...). Enter 0 in
the To Value box and a reference to the changing cell in the By Changing Cell
box, and press OK.
Figure 8-14. The Goal Seek dialog box.
After a few iteration cycles the Goal Seek Status dialog box (Figure 8-15)
will be displayed. When you press OK the final values of the changing cell and
target cell will be displayed in the worksheet cells, as shown in Figure 8-16.
Figure 8-15. The Goal Seek Status dialog box.
Figure 8-16. Obtaining a root of a function by using Goal Seek.
(folder 'Chapter 08 Examples', workbook 'Roots of Equations', worksheet 'Using Goal Seek')
For scientific and engineering problems, it's critical that you set the
convergence limit (the stopping parameter) of Goal Seek to suit your problem.
Choose Options ... from the Tools menu and choose the Calculation tab (see
