Investment Studio > Expressions > Functions > Reference > ADDRESS
string address(integer row_number, integer column_number, integer absolute = 1)
Returns a string containing a spreadsheet-style cell address for the specified row and column numbers.
The absolute argument determines the reference style:
| absolute = | Meaning |
| 1 or omitted | Absolute
style reference: both row and column are preceded by $
characters. Example: =address(4, 5, 1) returns $E$4. |
| 2 | Absolute
row, relative column. Example: =address(4, 5, 2) returns E$4. |
| 3 | Absolute
column, relative row. Example: =address(4, 5, 3) returns $E4. |
| 4 | Absolute
column, relative row. Example: =address(4, 5, 4) returns E4. |
As far as expression evaluation is concerned, the difference between absolute and relative references is immaterial. In spreadsheets, absolute references are used to ensure that copying a formula from one cell to another will leave the reference(s) in the formula unchanged, while relative references are automatically adjusted for the change in formula location. Investment Studio supports both forms for compatibility reasons.