Filter
Top Products
20060301
A constant is data whose value is defined when it is input. When you input something into a
cell for which text is specified as the data type without an equal sign (=) at the beginning, a
numeric value is treated as a constant and non-numeric values are treated as text.
Note the following examples for cells of
u
type:
This input: Is interpreted as: And is treated as:
sin(1) A numeric expression A constant value
1+1/2 A numeric expression A constant value
1.02389 A numeric expression A constant value
sin(
x
) A symbolic expression Text
x
+
y
A symbolic expression Text
Result A string expression Text
sin( Invalid expression context Text
• When text is too long to fit in a cell, it spills over into the next cell to the right if the
neighboring cell is empty. If the cell to the right is not empty, the text is cut off and “...” is
displayed to indicate that non-displayed text is contained in the cell.
13-4-8
Editing Cell Contents
(4) Tap the cell you want to reference (which will input its name into the edit box
automatically) or use the editing toolbar and keypad to input its name.
Important!
• The above step always inputs a relative cell reference. If you want to input an
absolute cell reference, use the stylus or cursor keys to move the editing cursor to the
appropriate location, and then use the editing toolbar to input a dollar ($) symbol. See
“Inputting a Cell Reference” on page 13-4-6 for more information about relative and
absolute cell references.
(5) Repeat step (4) as many times as necessary to input all of the cell references you
want. For example, you could input “=A1 + A2”. You can also input a range of cells into
the edit box by dragging across a group of cells.
(6) After your input is the way you want, tap the
s
button next to the edit box or press the
E
key to save it.
Inputting a Constant