HP 95LX - Page 64

Cell References
You reference cells via three values—range, row-in-range, column-in-range. For
example, the reference {D6 y2 34 refers to the cell in the 2nd row and the 4th
column of the range whose upper-lefthand cell is D6 (i.e., it refers to G7):
( De: [HB] lh
)
i
5
:
IRE
11
\_ J
The row and column numbers are not required; a missing number is assumed to
be 1. The upper-left cellin the designated range is row 1, column 1 (this is different
than in Lotus functions, where the upper-left cell in a range is row 0, column 0).
Using CALCCELL
CALCCELL needs two kinds of information:
a list of Solver variables, values, or expressions and the spreadsheet cells into
which you're putting them;
¢ the cell (range, row, column) whose value will be brought back into the Solver
as the result of the CALCCELL function.
For example, suppose you have a Solver equation that uses variables named
Basis Salvage Life, and Year#. Then here’s how you'd use the 1-2-3
function, @DDB, to find the double-declining depreciation allowance (DDB) of an
asset in any given Year # of its useful life:
64 2. ANALYZING INFORMATION