Returns a cell reference as a string, given the row and column numbers.
Syntax
row: A number specifying the row. E.g. 1
1- Row and column absolute ($A$1)
2- Row absolute and column relative (A$1)
3- Row relative and column absolute ($A1)
Remarks
When omitting an optional parameter in the syntax, use a ; or , to separate it from the next argument. For example, in =ADDRESS(1;2;;TRUE;"ADDRESS") the parameter mode has been omitted.
Examples
Formula | Result |
=ADDRESS(1;2;1;TRUE;"ADDRESS") | ADDRESS.$B$1 |
=ADDRESS(1;2;1;TRUE) | $B$1 |
=ADDRESS(1;2;2) | B$1 |
=ADDRESS(1;2;1;FALSE;"ADDRESS") | ADDRESS.R1C2 |
Possible Errors
Errors | Meaning |
#N/A! |
|
#NAME! |
|
#VALUE! |
|
#REF! |
|
Similar Functions
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Write to us: support@zohoforms.com