•
•
•
Reference
Sales
=
Costs
*
0.5
then
"Sales"
will also be a
row
label.
If
both of these rules
fall,
you
are told that Abacus cannot decide the meaning
of the label.
BDDDB
CK:J~
- - - -
FRUIT
~
!
APPLES
•
ILl
11,====='1
Figure
6,3
Labelling a
cell
You
need
to
use two labels
to
identify a single
cell
and you make the cell reference Cell Labels
by giving both labels, separated by a
full
stop.
For
example,
if
you have two labels
'~ruit"
and "apples':
you
can refer
to
a cell as
fruit.apples
(or by any unique abbreviation, such
as
frap). The order of the two labels
is
unimportant
so
you
could also use apples.fruit, ap.fr and
so
on.
Such a reference
refers
to
the cell
at
the intersection of the
row
s and columns containing
the labels but, as Figure
6.3
shows,
there
are
two such cells (labelled X and
Y).
The cell that
is
selected
is
the one
in
the right-most column and the lower of the two
rows.
In
the previous example, the cell labelled Y
will
be selected.
You
should, therefore,
always place labels above or
to
the
left
of
the
cells
to
which they refer
A formula
is
any allowed combination of functions, cell references, labels and arithmetic
FORMULAE
operators. Examples
are:
A1
*63
month(colO-1l
; f (
ins
t r
(86,
II;
s")
, 1
,0)
rept("=/I,
Len(G23»+":1I
Each new formula,
in
addition
to
being used
in
one or more grid
cells,
is
stored separately Master Formulae
in
a
list
of master formulae. Each master formula may therefore appear
in
one cell or
,n
many.
When
you
fill
cells by
use
of the
row
and column
fill
operations, or
by
uSing
the Copy or Echo commands,
all
the filled
cells
share a
Single
master formula.
If
a master
formula contains relative cell references they are adjusted,
in
each
cell
using the formula,
to
be valid for that particular location. The formulae may therefore appear superficially
different but are
all
based
on
the one master formula.
You
can modify
all
copies of the formula
by
editing only one of the copies.
If
you use
the Amend command
to
change any copy of a master formula, the master
is
also
modified and
all
copies are changed Simultaneously.
This section contains a
full
description of
all
the commands available
In
Abacus.
THE
COMMANDS
This command allows you
to
change the contents of a cell. The contents of the cell AMEND (A)
containing the cursor are copied
to
the input
line,
ready for editing with the line editor
described
in
the IntrOduction
to
the OL Programs. When you press ENTER the edited
version replaces the original cell contents.
To Next Page
Loading...
Need help?
General
