ChaDter
51
Worksheet
EXP(R4C3)
INT(R4C2)
LOG(R2C4)
MAX(C4)
MIN(R1)
RMT( #R4C3)
SGN(R3C4)
SIN(R2C1)
SQR(R5Cl)
SUM(R5)
TAN( R2C3)
Displays
e
raised to the power of the value of cell
R4C3 (Napierian, or natural exponential
ex).
Displays the truncated value of cell R4C2.
Displays the logarithm to the base
10
of the value
of cell R2C4.
Displays the maximum value of the current row,
beginning with Column 4, over to the current cell,
skipping any non-numeric data.
Displays the minimum value in the current column,
beginning with Row
1,
down to the current cell, skip-
ping any non-numeric data.
Gives a cumulative total for Row
4,
beginning with
Column
3.
For example:
c
3
IC
4
IC
5
3
141
5.00 10.00 20.00
151
If cells
3,
4,
and
5
of Row
5
are selected, and the
above formula
is
entered, calculation produces the
following results:
c
3
IC
4
IC
5
3
c41
5.00 10.00 20.00
c51
5.00 15.00 35.00
Displays the sign
of
the value in cell R3C4 (displays
1.00
if the argument is positive or zero, and
-
1.00
if
it
is negative).
Displays the sine of the value of cell R2C3 (use
SIN((R2C1)*.01745329)
if the value in cell R2C3 is
in degrees instead
of
radians).
Displays the square root
of
the value of cell
R5C1.
Displays the sum of the values in the current col-
umn, beginning with Row
5,
down to the current
cell, skipping any non-numeric data.
Displays the tangent
of
the value of cell R2C3 (use
TAN((R2C3)*.01745329)
if the value
of
cell R2C3
is in degrees instead of radians)
Tandy
1000
39
To Next Page
Loading...
Need help?
General
