User Manual

9-15
• To insert columns
Starting with the column immediately to the right of the column where you want the insert
to be performed, select the same number of columns that you want to insert.
Example: To insert three columns to the left of column B, you could select B2:D4,
B10:D20, etc.
2. Press 4(INS).
• This will enter insert standby. If you decide you want to cancel the insert operation at this
time, press J.
3. Press 1(ROW) to insert the applicable number of rows or 2(COL) to insert columns.
• A Range ERROR occurs if an insert operation causes existing cells that contain data to
move outside the range of A1:Z999.
u To clear the contents of specific cells
Select the cell or range of cells you want to clear and then press 5(CLR).
3. Using Special S
•
SHT Mode Commands
The S
•
SHT mode has a number of special commands like CellSum(, which returns the sum
of a range of cells, and CellIf(, which specifies branching conditions. These special commands
can be used inside of formulas.
k Special S
•
SHT Mode Command List
“Input Key Operation” operations can be performed during cell input only.
You can omit anything enclosed in brackets ([ ]) in the Syntax of each command.
Command Description
CellIf(
(Branch Condition)
Returns Expression 1 when the equality or inequality provided as
the branch condition is true, and Expression 2 when it is false.
Input Key Operation: 4(If)
Syntax: CellIf(equality, expression 1, expression 2[)] or
CellIf(inequality, expression 1, expression 2[)]
Example: =CellIf(A1>B1, A1, B1)
Returns the value of A1 when {Cell A1 value} > {Cell B1 value}.
Otherwise, returns the value of B1.
CellMin(
(Cell Minimum Value)
Returns the minimum value in a specified range of cells.
Input Key Operation: 5(CEL) 1(Min)
Syntax: CellMin(start cell:end cell[)]
Example: =CellMin(A3:C5)
Returns the minimum value of the data in cell range A3:C5.
CellMax(
(Cell Maximum Value)
Returns the maximum value in a specified range of cells.
Input Key Operation: 5(CEL) 2(Max)
Syntax: CellMax(start cell:end cell[)]
Example: =CellMax(A3:C5)
Returns the maximum value of the data in cell range A3:C5.