writer
6,694
edits
Changes
no edit summary
<div style="font-size:25px">'''ADDRESS (RowNumber,ColumnNumber,AbsoluteOption,ReferenceStyle,TableName)'''</div><br/>
*<math>RowNumber</math> is the row number
*<math>ColumnNumber</math> is the column number
*<math>AbsoluteOption</math> the type of reference to return
*<math>ReferenceStyle</math> is the logical value
*<math>TableName</math> is the name of the Calci worksheet to be used as the external reference.
**ADDRESS(), returns a reference as text to a single cell in a worksheet.
==Description==
==Description==
*This function generates a cell address as text, given specified row and column numbers.
{|style="width:50%; height:100px" border="1"
|-
!AN
!Types of reference
|-
{|id="TABLE1" class="SpreadSheet blue"
|-
|-
|1 or omitted
|1 or omitted
|Absolute
|Absolute
|-
|-
|2
|2
|Absolute row,relative column
|Absolute row,relative column
|3
|3
|Relative row,absolute column
|Relative row,absolute column
|-
|-
|4
|4
|Relative
|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
==Related Videos==
{{#ev:youtube|nydCUYe00cU|280|center|ADDRESS}}
==See Also==
*[[Manuals/calci/COLUMN | COLUMN]]
*[[Manuals/calci/COLUMNS | COLUMNS]]
*[[Manuals/calci/ROW | ROW]]
*[[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]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]