The ADDRESS function calculates the location of a reference to a single cell and returns the location as text.
The row and column numbers determine the address and the mode number determines the mode. In Spreadsheet, for example, the row number will specify the row number of the spreadsheet, the column number will specify the column letter, and the mode number will specify whether the reference address is absolute or relative, according to the following key:
abs_mode |
Reference |
1 |
Absolute |
2 |
Absolute row, relative column |
3 |
Relative row, absolute column |
4 or omitted |
Relative |
For example:
ADDRESS(1,1,1) returns $A$1
ADDRESS(10,5,3) returns $E10
ADDRESS(100,200) returns GR100
See also: