Reference
II
.
===="J
B[JCDI~IIBDCIDEII
'I
. I
I,---------~
I , I
L:23J
I
L[XJ
!
U
rc~~==
Figure
6.1
Relative
cell
references
Figure
62
Absolute
cell
references
Suppose
we
put the tormula A1'2 into cell A2, and then use the Echo command
to
copy the formula
into
cells
in
the range
62:02.
Examining the cells of
row
2 will show
that they have
the
following contents:
Cell: A2
Contents: A
1'2
62
61'2
C2
C1'2
02
01'2
E2
E1'2
F2
F1'2
02
01'2
You
can make any
cell
reterence absolute by pretaclng
It
with a $ sign. Such a reference
will
not be modified when the formula
is
copied
to
other
cells.
For example,
if
a reference
in
cell
62
was
to
$A1,
any copy of the formula
will
also contain the reference
$At
You
can also use labels
to
give
an
absolute cell reference
(e.g.
$march.costs).
Figure
6.2
shows the
effect
of an absolute
cell
reference. A formula
in
cell X contains
an
absolute reference
to
the shaded cell. A copy of the formula
in
cell Y refers
to
the
same
cell.
Let
us
try the prevIous example, but this time
we
shall
use
an absolute reference. Put
the formula
$A1'2
in
cell A2 and Echo
It
to
cells
62
to
02
inclusive.
You
will then find
that the cells contain the following:
Cell A2
Contents:
$A
1'2
62
$A1'2
C2
$A1'2
02
$A1'2
E2
$A1'2
F2
$A1'2
02
$A1'2
See also the index( ) function.
Cell ranges,
in
any form (including the range identifiers,
row
and col) are always
relative.
LABELS
Rowand Column
Labels
A label
is
a
cell
containing text The text must only Include letters and digits. Any such
cell
can be used
to
identify a
row
or column
in
the grid.
You
can also use labels
to
refer
to
a single
cell,
but
you
may not use them
to
replace a range reference or
to
refer
to
a whole block of
cells.
Whenever
you
refer
to
a label
in
an expression or formula, Abacus uses a set of rules
to
determine whether
it
refers
to
a
row,
a column or a
cell.
The rules
for
rows
and columns
are:
2
The
row
and column Intersecting
at
the label are scanned
(to
the right and below)
to
find the numeric entry.
a)
If
only a
row
entry
IS
found, the label refers
to
the
row,
starting at the found
entry.
b)
If
only a column entry
is
found, the label refers
to
the column, starting
at
the found
entry.
c)
If
entries are found
in
both the
row
and the column, the entry closest
to
the
labelled cell
is
used
to
make the choice.
If
no decision can be made under
1),
but the label
is
used
on
the left hand side
of an expression,
it
will
be given the type of any label(s) used on the right hand
side.
For example,
if
"Costs"
is
a row label:
36
12/84
To Next Page
Loading...
Need help?
General
