Spread Formula Reference
ADDRESS
Formula Functions > Functions A to C > ADDRESS

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)

Version Available

This function is available in product version 2.0 or later.

See Also

COLUMNS | ROWS | INDEX | Lookup Functions