Documentation/How Tos/Calc: ADDRESS function

ADDRESS

Returns a cell reference as text, given row and column numbers.

Syntax:

ADDRESS(row; column; mode; sheet)

row is a number specifying the row.

column is a number (not a letter) specifying the column.

mode (an optional number) determines whether the cell address is absolute or relative. If omitted, it is assumed to be 1.

mode	row	column	example
1	absolute	absolute	$A$1
2	absolute	relative	A$1
3	relative	absolute	$A1
4	relative	relative	A1

sheet is an optional text string specifying the sheet.

Example:

ADDRESS(4; 3; 2; "Sheet2")

returns the text Sheet2.C$4.

ADDRESS(4; 3; 4)

returns the text C4.

ADDRESS(4; 3)

returns the text $C$4.

See also:

INDIRECT

Spreadsheet functions

Functions listed alphabetically, Functions listed by category

Issues:

The proposed ODFF standard says that the default mode (if mode is omitted) should be 4. Calc defaults to 1.