Navigation:  Formula Reference > Spreadsheet Formula Functions >

ADDRESS

Previous pageReturn to chapter overviewNext page

 

This function uses the row and column numbers to create a cell address in text.

Syntax

ADDRESS(row,column,absnum,a1style,sheettext)

Arguments

This function has these arguments:

Argument

Description

row

Row number in the cell reference

column8

Column number in the cell reference

absnum

[Optional] Type of reference to return; can be any of:

 

Value - Type of Cell Reference Returned

 

1 or omitted - Absolute

 

2 - Absolute row, relative column

 

3 - Relative row, absolute column

 

4 - Relative

a1style

[Optional] Logical value that indicates whether the reference style is A1; if TRUE or omitted, the style is A1; if FALSE, then the style is R1C1

sheettext

[Optional] Name of the sheet to use as an external reference; if omitted, no sheet name is used

Data Types

Accepts numeric and string data. Returns string data.

Examples

ADDRESS(2,4,2,FALSE)

 

See Also

COLUMNS

INDEX

ROWS