13-7-4

Cell and List Calculations

Cell Calculation and List Calculation Functions

This section provides explanations of the functions, input syntax, and examples for each of the cell calculation and list calculation functions included on the [Calc] menu. Please note that “start cell:end cell” is equivalent to entering a list.

S Cell-Calculation - row

Function: Returns the row number of a specified cell.

Syntax: row(cell)

Example: To determine the row number of cell A7 and input the result in cell A1:

S Cell-Calculation - col

Function: Returns the column number of a specified cell.

Syntax: col(cell)

Example: To determine the column number of cell C9 and input the result in cell A1:

20090601