Spread Formula Reference
Formula Functions / Functions A to C / ADDRESS
In This Topic
    ADDRESS
    In This Topic

    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