Reference
(C3)
-
(RlC4)
Cl*C2
(RlC2)/100
C6R3!3
ABS(R2C3)
ATN( R3
C
5)
AVG(
C
1)
CMT( #R4C3)
COS(R3C5)
Subtracts the value of the cell in Row
1,
Column
4
from the value of the cell in Column
3
of the cur-
rent row.
Multiplies
2
cells in the same row.
Divides the value
of
the cell in Row
1,
Column
2
by
100.
Calculates the cube of the value of the cell in Row
3,
Column
6.
Multiplies the value of the cell in Row
2,
Column
3
by
-1
if (and only if) it is
a
negative number
(absolute value).
Displays the arctangent of the value of cell
R3C5-the angle that has its tangent equal to the
value of cell R3C5. (The result displays in radians;
use
ATN(R3C5)*57.29578
to display the arctangent
in degrees.)
Adds all the values in the current row, beginning
with Column 1, over to the current cell, skipping any
non-numeric data, and divides by the number of
numeric cells added.
Gives a cumulative total for Column
3,
beginning
with Row
4.
For example:
c31c41
c
4
1
5.00
c
5
1 10.00
C
6
1
20.00
If cells
4,
5, and
6
of Column
4
are selected and the
above formula is entered, calculation produces the
following results:
C31C41
c
4
1
5.00 5.00
c
5
1
10.00
15.00
C
6
1 20.00 35.00
Displays the cosine of the value of cell R3C5. (Use
COS((R3C5)*.01745329)
if the value in cell R3C5
is
in degrees instead of radians.)
38
Tandy
1000
To Next Page
Loading...
