Bots, writer
193,448
edits
Changes
Jump to navigation
Jump to search
Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=..."
<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
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="297" cellpadding="2"
|-
| width="81" |
'''AN'''
| width="208" |
'''types of reference'''
|-
| width="81" |
1 or omitted
| width="208" |
Absolute
|-
| width="81" |
2
| width="208" |
Absolute row,relative column
|-
| width="81" |
3
| width="208" |
Relative row,absolute column
|-
| width="81" |
4
| width="208" |
Relative
|}
<br /><br />
'''A1''' is a logical value
CText is text specifying the name of the calcisheet to be used as the external reference.
</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>
----
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="297" cellpadding="2"
|-
| width="81" |
'''AN'''
| width="208" |
'''types of reference'''
|-
| width="81" |
1 or omitted
| width="208" |
Absolute
|-
| width="81" |
2
| width="208" |
Absolute row,relative column
|-
| width="81" |
3
| width="208" |
Relative row,absolute column
|-
| width="81" |
4
| width="208" |
Relative
|}
<br /><br />
'''A1''' is a logical value
CText is text specifying the name of the calcisheet to be used as the external reference.
</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>
----