13-4-8

Editing Cell Contents

Inputting a Constant

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 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 non-displayed text is contained in the cell.

Using the Fill Sequence Command

The Fill Sequence command lets you set up an expression with a variable, and input a range of values based on the calculated results of the expression.

u To input a range of values using Fill Sequence

Example: To configure a Fill Sequence operation according to the following parameters

Expression:

1/x

Change of x Value: From 1 to 25

Step:

1

Input Location:

Starting from A1

(1) On the [Edit] menu, tap [Fill Sequence].

20050501