User Manual

9-9
• Performing the next step will input the number string automatically starting from the
specified cell. If any cell that is within the range of cells where the number sequence
values will be input already contains data, the existing data will be replaced with the
number sequence values.
3. After inputting data for all the setting items, press 6(EXE) or the w key to start number
sequence generation and input.
k Inputting Text into a Cell
To input text, make sure the first thing you input into the cell is a5(”). The quote mark (")
tells the calculator that what follows is text, and should be displayed as-is without calculation.
The quote mark (") is not displayed as part of the text.
k Inputting a Formula into a Cell
For the sake of example, let’s try making a table that contains data based on the formula
<PRICE> × <QUANTITY> = <TOTAL>. To do this, we would put <PRICE> values in column
A, <QUANITY> values in column B, and calculation formulas (like = A1 × B1, = A2 × B2, and
so on) in column C. If the Auto Calc feature is enabled (On), the values in column C would be
recalculated and updated any time we change the values in column A or B.
In this example, note that we must start out the data in column C with the equal sign (=) in
order to indicate it is a formula. In addition to values, arithmetic operators, and cell reference
names, a formula also can contain built-in function commands (page 2-13) and special S
•
SHT
mode commands (page 9-15).
u Formula Input Example
A B C
1 PRICE QUANTITY TOTAL
2 35 15 525
3 52 15 780
4 78 20 1560
Procedure
1. Input the text for line 1, and the applicable values in cells A2 through B4.
2. Move the cursor to cell C2, and input the formula for A2 × B2.
!.(=) av(A) c*al(B) cw
⇒