HP 95LX - Page 66

Creating and Using a “Solver” Worksheet
A “normal” worksheet treats the formula cell differently than its referenced cells.
You can work backward from a formula’s desired result to solve for any cell value
referenced by it, but backsolving is still a special operation. By contrast, the Solver
offers either input or output status for any variable—automatically. Wouldn't it
be great if you could create a 1-2-3 spreadsheet with that same flexibility?
You can: You can create a “Solver worksheet” with simple data cells for all
variables, including the one normally thought of as “the answer.” Then, in an
additional cell, you enter the formula that relates all of the variables—written as
an expression equal to zero, as are many Calculator Solver equations.
To set up a “Solver” worksheet:
1. Reserve a set of cells for each of the variables in the expression and one extra
one below them for the formula cell.
2. Create your formula cell by typing an expression that is equal to zero and
entering it into a cell.
3. Make the cursor is still in the formula cell, and press [E), (MENU), (Solve, (and
pressing one or more times) in order to display.
4. Press (Him), (SEED), to designate the formula cell.
5. Type B and press (EIMAID) to set the Solver formula cell equal to zero.
To use a “Solver” worksheet:
1. Make sure the Calculator is open to a solve catalog display (press (&), (MENU),
(Sholve, and then one or more times), and then press (NEEEm=).
2. Press (123) and open the “Solver” worksheet.
3. Enter values into all but one of the variable cells.
4. Move the cursor to the unknown variable’s cell, and press (&), (F10) (EIB EE
ENTER). The result is displayed in the Calcline. Press (123) to return to the
worksheet and see the result entered there as well.
66 2. ANALYZING INFORMATION