Using Excel to Solve Nonlinear Equations Goal Seek

3 USING EXCEL TO SOLVE NONLINEAR EQUATIONS (GOAL SEEK) 

Therefore, the algorithm used by Goal Seek is somewhat similar to the secant method with some enhancements. If Goal Seek fails, it is usually due to a poor initial 

In the following spreadsheet, cell Bl contains the initial guess for the independent variable, x. When a correct value is found for x, then the function/(x) = 0 [the formula for fix) is in cell B2 and is = Bl-Bl (1/3) - 2], 

The following is the Goal Seek window obtained from the Data/What If Analysis/Goal Seek Menu. 

After hitting the OK button on the Goal Seek window, the spreadsheet changes 

---