writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − Syntax+ + + + + + − </div></div> − ---- − <div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify"> − Examples-1+ + − </div></div>+ − ----+ − <div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div>+ − ----+ − <div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify">+ − + − <font size="5">Description</font>+ − + − </div></div>+ − ----+ − <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="81" | − '''AN''' − | width="208" | − '''types of reference''' − − − − − − + − 2+ − | width="208" |+ − Absolute row,relative column+ − |-+ − | width="81" | − − − − − − − − − − <br /><br /> − − </div></div>+ − ----+ − <div id="1SpaceContent" class="zcontent" align="left">+ + + + + − {| id="TABLE3" class="SpreadSheet blue"+ − |- 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+ − </div>+ − ----+ − <div id="7SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">+ + + − Examples-1+ + − </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>+ − </div>+ − ----
no edit summary
<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
<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==
*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
|-
|1 or omitted
|Absolute
|-
|2
|Absolute row,relative column
{| width="297" cellpadding="2"
|-
|-
| width="81" |
1 or omitted
| width="208" |
Absolute
|-
|-
| width="81" |
|3
|Relative row,absolute column
|-
|4
|Relative
3
| width="208" |
Relative row,absolute column
|-
| width="81" |
4
| width="208" |
Relative
|}
|}
'''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.
==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 ]]