Formulas and Functions

Table Of Contents

A1 (TRUE, 1, or omitted): The address format should use letters for columns and

numbers for rows.

R1C1 (FALSE): The address format isn’t supported, returning an error.

Â table: An optional value specifying the name of the table. table is a string value.

If the table is on another sheet, you must also include the name of the sheet. If

omitted, table is assumed to be the current table on the current sheet (that is, the

table where the ADDRESS function resides).

Usage Notes

An address style of R1C1 is not supported and this modal argument is provided only Â

for compatibility with other spreadsheet programs.

Examples

=ADDRESS(3, 5) creates the address $E$3.

=ADDRESS(3, 5, 2) creates the address E$3.

=ADDRESS(3, 5, 3) creates the address $E3.

=ADDRESS(3, 5, 4) creates the address E3.

=ADDRESS(3, 3, ,, “Sheet 2 :: Table 1”) creates the address Sheet 2 :: Table 1 :: $C$3.