Filter
Top Products
9-14
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.
I 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: (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: (CEL)(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: (CEL)(Max)
Syntax: CellMax(start cell:end cell[)]
Example: =CellMax(A3:C5)
Returns the maximum value of the data in cell range A3:C5.
CellMean(
(Mean of Cells)
Returns the mean value in a specified range of cells.
Input Key Operation: (CEL)(Mean)
Syntax: CellMean(start cell:end cell[)]
Example: =CellMean(A3:C5)
Returns the mean value of the data in cell range A3:C5.
CellMedian(
(Median of Cells)
Returns the median value in a specified range of cells.
Input Key Operation: (CEL)(Med)
Syntax: CellMedian(start cell:end cell[)]
Example: =CellMedian(A3:C5)
Returns the median value of the data in cell range A3:C5.
CellSum(
(Sum of Cells)
Returns the sum of the data in a specified range of cells.
Input Key Operation: (CEL)(Sum)
Syntax: CellSum(start cell:end cell[)]
Example: =Cellsum(A3:C5)
Returns the sum of the data in cell range A3:C5.