| Line 1: |
Line 1: |
| − | <div id=" 16SpaceContent" align="left"><div class="ZEditBox" align="justify"> | + | <div style="font-size:25px">'''ADDRESS (RowNumber,ColumnNumber,AbsoluteOption,ReferenceStyle,TableName)'''</div><br/> |
| | | | |
| − | Syntax
| + | *<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. |
| | | | |
| − | </div></div>
| |
| − | ----
| |
| − | <div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify">
| |
| | | | |
| − | Examples-1
| + | ==Description== |
| | + | *This function generates a cell address as text, given specified row and column numbers. |
| | | | |
| − | </div></div>
| + | {|style="width:50%; height:100px" border="1" |
| − | ----
| + | |- |
| − | <div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div>
| + | !AN |
| − | ----
| + | !Types of reference |
| − | <div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify">
| + | |- |
| − | | + | |1 or omitted |
| − | <font size="5">Description</font>
| + | |Absolute |
| − | | + | |- |
| − | </div></div>
| + | |2 |
| − | ----
| + | |Absolute row,relative column |
| − | <div id="5SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">This function generates a cell address as text, given specified row and column numbers. </font></font></font></div></div>
| |
| − | ----
| |
| − | <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="6">ADDRESS</font></div></div>
| |
| − | ----
| |
| − | <div id="6SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
| |
| − | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ADDRESS(RN,CN,AN,A1,CText)'''</font></font></font>
| |
| − | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">where RN''' '''</font></font></font>is the row number ,CN is the column number to use in the cell reference.
| |
| − | | |
| − | AN specifies the type of reference to return.
| |
| − | | |
| − | <br /><br />
| |
| − | | |
| − | <br /><br />
| |
| − | | |
| − | {| width="297" cellpadding="2" | |
| − | |- | |
| − | | width="81" |
| |
| − | '''AN'''
| |
| − | | width="208" |
| |
| − | '''types of reference'''
| |
| − | |- | |
| − | | width="81" | | |
| − | 1 or omitted | |
| − | | width="208" | | |
| − | Absolute | |
| | |- | | |- |
| − | | width="81" | | + | |3 |
| − | 2
| + | |Relative row,absolute column |
| − | | width="208" |
| + | |- |
| − | Absolute row,relative column
| + | |4 |
| − | |-
| + | |Relative |
| − | | width="81" |
| |
| − | 3 | |
| − | | width="208" | | |
| − | Relative row,absolute column | |
| − | |- | |
| − | | width="81" | | |
| − | 4 | |
| − | | width="208" | | |
| − | Relative | |
| | |} | | |} |
| − |
| |
| − | <br /><br />
| |
| | | | |
| | '''A1''' is a logical value | | '''A1''' is a logical value |
| − |
| |
| | CText is text specifying the name of the calcisheet to be used as the external reference. | | CText is text specifying the name of the calcisheet to be used as the external reference. |
| | | | |
| − | </div></div>
| + | ==Examples== |
| − | ----
| + | *=ADDRESS(2,3) : Table1!$C$2 |
| − | <div id="1SpaceContent" class="zcontent" align="left">
| + | *=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 |
| | | | |
| − | {| id="TABLE3" class="SpreadSheet blue"
| + | ==Related Videos== |
| − | |- class="even"
| |
| − | | class=" " |
| |
| − | | Column1
| |
| − | | Column2
| |
| − | | Column3
| |
| − | | Column4
| |
| − | |- class="odd"
| |
| − | | class=" " | Row1
| |
| − | | class="sshl_f" | TABLE3!$C$4
| |
| − | | class=" " |
| |
| − | |
| |
| − | |
| |
| − | |- class="even"
| |
| − | | class=" " | Row2
| |
| − | | class=" " |
| |
| − | | class="SelectTD" |
| |
| − | |
| |
| − | |
| |
| − | |- class="odd"
| |
| − | | Row3
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |- class="even"
| |
| − | | Row4
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |- class="odd"
| |
| − | | class=" " | Row5
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |- class="even"
| |
| − | | Row6
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |}
| |
| − | | |
| − | <div align="left">[[Image:calci1.gif]]</div></div>
| |
| − | ----
| |
| − | <div id="4SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | '''Let's see an example in Column1Row1'''
| |
| | | | |
| − | I.e.=ADDRESS(4,3) is TABLE3!$C$4
| + | {{#ev:youtube|nydCUYe00cU|280|center|ADDRESS}} |
| | | | |
| − | </div>
| + | ==See Also== |
| − | ----
| + | *[[Manuals/calci/COLUMN | COLUMN]] |
| − | <div id="7SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
| + | *[[Manuals/calci/COLUMNS | COLUMNS]] |
| | + | *[[Manuals/calci/ROW | ROW]] |
| | + | *[[Manuals/calci/CELL | CELL]] |
| | | | |
| − | Examples-1
| + | ==References== |
| | + | *[https://support.office.com/en-sg/article/ADDRESS-function-47657e92-81ae-47f8-87cd-62d4f30c774d?ui=en-US&rs=en-SG&ad=SG Address] |
| | | | |
| − | </div></div>
| |
| − | ----
| |
| − | <div id="9SpaceContent" class="zcontent" align="left">
| |
| | | | |
| − | {| id="TABLE4" class="SpreadSheet blue"
| |
| − | |- class="even"
| |
| − | | class=" " |
| |
| − | | Column1
| |
| − | | Column2
| |
| − | | Column3
| |
| − | | Column4
| |
| − | |- class="odd"
| |
| − | | class=" " | Row1
| |
| − | | class="sshl_f " | TABLE4!C$4
| |
| − | | class=" " |
| |
| − | |
| |
| − | |
| |
| − | |- class="even"
| |
| − | | class=" " | Row2
| |
| − | | class=" " |
| |
| − | | class="SelectTD" |
| |
| − | |
| |
| − | |
| |
| − | |- class="odd"
| |
| − | | Row3
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |- class="even"
| |
| − | | Row4
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |- class="odd"
| |
| − | | class=" " | Row5
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |- class="even"
| |
| − | | Row6
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |}
| |
| | | | |
| − | <div align="left">[[Image:calci1.gif]]</div></div>
| |
| − | ----
| |
| − | <div id="12SpaceContent" class="zcontent" align="left">
| |
| | | | |
| − | <nowiki>=ADDRESS(4,3,2) is TABLE3!C$4)</nowiki>
| + | *[[Z_API_Functions | List of Main Z Functions]] |
| | | | |
| − | </div>
| + | *[[ Z3 | Z3 home ]] |
| − | ----
| |