Difference between revisions of "Manuals/calci/ADDRESS"
Jump to navigation
Jump to search
| Line 43: | Line 43: | ||
*[[Manuals/calci/ROW | ROW]] | *[[Manuals/calci/ROW | ROW]] | ||
*[[Manuals/calci/CELL | CELL]] | *[[Manuals/calci/CELL | CELL]] | ||
| + | |||
| + | ==References== | ||
| + | *[https://support.office.com/en-sg/article/ADDRESS-function-47657e92-81ae-47f8-87cd-62d4f30c774d?ui=en-US&rs=en-SG&ad=SG Address] | ||
Revision as of 12:00, 14 May 2015
ADDRESS (RowNumber,ColumnNumber,AbsoluteOption,ReferenceStyle,TableName)
- RowNumber is the row number
- ColumnNumber is the column number
- AbsoluteOption specifies the type of reference to return
- ReferenceStyle is the logical value
- TableName is the name of the Calci worksheet to be used as the external reference.
Description
- This function generates a cell address as text, given specified row and column numbers.
| AN | Types of reference |
|---|---|
| 1 or omitted | Absolute |
| 2 | Absolute row,relative column |
| 3 | Relative row,absolute column |
| 4 | Relative |
A1 is a logical value CText is text specifying the name of the calcisheet to be used as the external reference.
Examples
- =ADDRESS(2,3) : Table1!$C$2
- =ADDRESS(2,3,1) : Table1!$C$2
- =ADDRESS(2,3,2) : Table1!C$2
- =ADDRESS(2,3,3) : Table1!$C2
- =ADDRESS(2,3,4) : Table1!C2
- =ADDRESS(2,3,4,"FALSE","CALCI") : CALCI!C2