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
(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 sbutton next to the edit box or press the
Ekey to save it.
Inputting a ConstantA 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
Note the following examples for cells of utype:
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
20060301