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.

ISpecial 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(

Returns Expression 1 when the equality or inequality provided as

(Branch Condition)

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(

Returns the minimum value in a specified range of cells.

(Cell Minimum Value)

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(

Returns the maximum value in a specified range of cells.

(Cell Maximum Value)

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(

Returns the mean value in a specified range of cells.

(Mean 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(

Returns the median value in a specified range of cells.

(Median 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(

Returns the sum of the data in a specified range of cells.

(Sum 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.

 

 

9-14