EasyManua.ls Logo

Commodore Plus 4 - Page 139

Commodore Plus 4
464 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...
Sections.
Spreadsheet
Commands
127
FIT
SS
Copies
a
formula
from
a
cell
into
another
cell
and
adjusts
the
formula
to
fit
the
new
cell.
To
use
FIT,
move
the
cell
cursor
to
the
cell
where
you
want
the
adjusted
formula
to
appear.
Then
type
FIT
and
the
cell
number
of
the
cell
whose
formula
you
want
to
adapt.
The
FIT
command
automatically
changes
the
cell
numbers
in
the
formula
to
fit
the
new
cell.
When
you
use
the
FIT
command
in
manual
calculation
mode,
the
solution
to
the
FITted
formula
is
not
calculated.
Instead,
the
solution
to
the
original
formula
is
displayed
in
the
new
cell.
You
must
enter
auto
calculation
mode
to
solve
FITted
formulas.
As
soon
as
you
enter
auto
mode,
all
FITted
formulas
in
the
work
area
are
solved
and
the
answers
are
displayed
in
the
appropriate
cells.
If
you
are
already
in
auto
mode
when
you
enter
a
FITted
formula,
the
correct
solution
to
the
FITted
formula
is
displayed
automatically
in
the
new
cell.
For
example,
if
the
formula
in
cell
3;6
is
SUM
3;2
TO
3;5,
and
you
move
the
cursor
to
cell
4;6
and
issue
the
command
FIT
3;6,
the
computer
changes
the
formula
to
SUM
4;2
TO
4;5.
The
difference
between
the
formulas
is
that
the
row
number
has
been
adjusted
to
match
the
difference
between
the
row
of
the
original
formula
(row
3)
and
the
row
of
the
FITted formula
(row
4).
When
the
FITted
formula
is
adjusted,
the
computer
measures
the
difference
between
the
row
and
column
locations
where
the
original
formula
appeared
and
the
row
and
column
coordinates
of
the
cell
where
you
issued
the
FIT
command.
Row
and
column
number
differences
are
then
used
to
adjust the
formula
in
the
new
cell.
Example:
With
the
cell
cursor
in
cell
7;5,
issue
the
command
FIT4;3.
Cell
4;3
contains
this
formula;
sum
1;3
to
3;3.
The
formula
is
adjusted
to
be
sum
4;5
to
6;5.
The
difference
between
cells
7;5
and
4;3
is
three
rows
and
two
columns.
To
adjust
the
formula
from
cell
4;3,
the
computer
adds
three
rows
to
each
row
and
two
columns
to
each
column
in
the
formula.
The
resulting
cell
numbers
in
the
formula
are
calculated
l+3;3+2
TO
3+3;3+2,
or
sum
4;5
to
6;5.
FL
SS
Returns
numeric
cell
entries
to
the
default
floating
point
format.
Floating
point
numbers
have
a
variable
number
of
decimal
places.
The
decimal
point
"floats"
to
the
appropriate
place
in
the
number.
Use
the
FL
(FLoating
point)
command
when
you
want
to
cancel
an
IN
(integer
format)
or
$$
(two-decimal-place
dollar
format)
command.
Current
cell
entries
are
not
affected
when
you
change
the
numeric
display
format.
If
you
change
the
format
and
want
to
adjust
current
cell
entries,
move
the

Other manuals for Commodore Plus 4

Preview: User Manual
User Manual234 pages
Preview: Service Manual
Service Manual26 pages

Related product manuals