Solving a Problem Using Goal Seek

Excel provides a built-in way to perform Newton-Raphson approximations the Goal Seek command in the Tools menu. Goal Seek varies the value of a selected cell (the changing cell) to make the value of another cell (the target cell) reach a desired value. 

To illustrate, let s repeat the calculation of the solubility of barium carbonate. Goal Seek allows you to obtain the same result much more easily. Open a new worksheet and in cell A1 enter the value 1. In cell B1, enter the formula =A1 2 -1.0E-6 SQRT(A1)-5.1 E-9. The task now will be to use Goal Seek... to find the value in cell A1 that makes the function (in B1) equal to zero. 

171] Save external nk values n Accept labels in formulas 

Goal Seeking with Cell B1 found a solution. 

Trial Maximum change Final value ofF(x) Value of X 

---

To obtain concentration information (x) from a flame photometer reading (y), it is necessary to find the value of x that gives the observed value of y. The Goal Seek command in Tools menu performs this task very conveniently (see "Solving a Problem Using Goal Seek..." in Chapter 10). 

---