AccessMyLibrary provides FREE access to millions of articles from top publications available through your library.
Create a link to this page
Copy and paste this link tag into your Web page or blog:
Backsolver: Solver's simpler sibling. (Lotus 1-2-3/G's Backsolver utility) (tutorial)
BACKSOLVER: SOLVER'S SIMPLER SIBLING
Have you ever built a model with a specific bottom line in mind, only to find that the results don't quite meet expectations? If your problem can be expressed as a chain of formulas, then 1-2-3/G's Backsolver utility can provide the solution.
Consider the common problem of qualifying for a mortgage, shown in simple form in the figure below. The five variables in this calculation are salary, other income, the mortgage amount, the mortgage interest rate, and the mortgage term. To build this problem in your worksheet, enter the variables and labels shown in the figure, and add the following formulas:
Cell Formulas …
