Excel 2000 in a Nutshell

Name

ADDRESS

Synopsis

Use ADDRESS to create a reference to a specific cell as text by specifying the desired row and column location as numeric values. For example, to refer to cell B2 you would reference column B as 2 for the Column_Num argument and row 2 as 2 for the Row_Num argument.

To Calculate

=ADDRESS(Row_Num, Column_Num, Abs_Num, A1, Sheet_Text)

The Row_Num and Column_Num arguments are required for this function. All other arguments are optional.

Abs_Num

This optional argument specifies an integer value of 1, 2, 3, or 4 indicating the type of cell reference to return.

1

Absolute reference. If the contents of the cell are cut or copied the address does not change. This is the default value if the argument is omitted.

2

Absolute reference for row but relative reference for column. For example, if the address is B$3 the row would remain 3 if the cell is copied or pasted but the column would change depending upon where the cell is pasted.

3

Absolute reference for column but relative reference for row. For example, if the address is $B3 the column would remain B if the cell is copied or pasted but the row would change depending upon where the cell is pasted.

4

Relative reference to both row and column. For example, if the reference is to cell B3 and the reference is copied and placed in the adjacent cell the pasted reference would be C3.

A1

This optional argument specifies a logical value of TRUE or FALSE that indicates the style used to represent the cell address. If the value is TRUE