Formulas and Functions

Table Of Contents

Related Topics

For related functions and additional information, see:

“Listing of Reference Functions” on page 206

“Value Types” on page 36

“The Elements of Formulas” on page 15

“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26

“Pasting from Examples in Help” on page 41

COLUMN

The COLUMN function returns the column number of the column containing a

specied cell.

COLUMN(cell)

Â cell: An optional reference to a single table cell. cell is a reference value to a single

cell that can contain any value, or be empty. If cell is omitted, as in =COLUMN(), the

function returns the column number of the cell that contains the formula.

Examples

=COLUMN(B7) returns 2, the absolute column number of column B.

=COLUMN() returns the column number of the cell that contains the function.