EasyManua.ls Logo

HP 95LX - Page 65

HP 95LX
164 pages
Save Page as PDF
Print Icon
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Loading...
.
Set
up
a
small
section
of
a
worksheet
that
provides:
a)
cells
in
which
to
input
the
Solver
variables
(or
expressions).
b)
a
cell
with
the
necessary
BDDB
formula
referencing
the
cells
that
receive
the
Solver
variables.
Open
the Solver
equation
and
use
CALCCELL
and
the
1-2-3
cells
you
just
set
up:
CALCCELLCLCBASISycell1l,
[SALVAGE
5
celi21
[LIFE
scell3],
CYERR#
5
cell]
5
pormula
cell
(with
BDDB
cell
1
ycell2
ycell3
scell4
?
Press
(MEMS)
to
initiate
the
calculation
template.
Enter
values
into
the
four
variables
in
the
input
list.
Solve
for
DDB
by
pressing
its
function
key.
The
CALCCELL
will
load
the
values
of
the
variables
into
the
spreadsheet,
where
the
DDBis
calculated,
and
the
retrieve
the
result
back
into Solver,
where
you'll
see
it
on
the
Calcline.
Using
the
Calculator
to
Backsolve
for
a
1-2-3
Formula
Normally
in
a
spreadsheet,
a
formula
cell
is
calculated
after
values
are
entered
into
every
cell
it
references.
But
with
the
Solver’s
backsolving
capability,
you
can
calculate
the
value
that
a
referenced
cell
must
have
in
order
to
produce
a
given
result
in
the
formula
cell.
®
NSA
Open
a
1-2-3
worksheet
containing
a
formula
cell
and
the
cells
it
references.
Enter
values
for
all
but one
of
the
referenced
cells.
Move
the
cursor
to
the
formula
cell.
Press
2),
(MENU),
(Slolve
(and
a
few
times)
to
show
the
solve
catalog.
Press
(HES),
(HIRI),
ENTER).
Type
the
value
of
the
desired
result
into
the
formula
cell;
press
(EIR).
Press
(
Move
the
cursor
to
the
one
referenced
cell
without
a
value,
and
press
[ENTER).
The
cell’s
value
is
calculated,
displayed
in
the
solve
1-2-3
screen,
and
placed
in
the
worksheet.
=P
R=)
to
display
the
current
worksheet.
Using
the
Solver
65

Table of Contents

Related product manuals