| Line 1: |
Line 1: |
| − | <div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
| |
| | | | |
| − | Syntax
| |
| | | | |
| − | </div></div>
| + | ==Description== |
| − | ----
| |
| − | <div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify">
| |
| | | | |
| − | Examples-1
| + | This function generates a cell address as text, given specified row and column numbers. '''ADDRESS(RN,CN,AN,A1,CText)''' |
| | | | |
| − | </div></div>
| + | >where RN''' '''is the row number ,CN is the column number to use in the cell reference. |
| − | ----
| |
| − | <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. | | AN specifies the type of reference to return. |
| | | | |
| − | <br /><br />
| |
| − |
| |
| − | <br /><br />
| |
| | | | |
| | {| width="297" cellpadding="2" | | {| width="297" cellpadding="2" |
| Line 63: |
Line 38: |
| | |} | | |} |
| | | | |
| − | <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>
| |
| − | ----
| |
| − | <div id="1SpaceContent" class="zcontent" align="left">
| |
| | | | |
| | {| id="TABLE3" class="SpreadSheet blue" | | {| id="TABLE3" class="SpreadSheet blue" |
| Line 117: |
Line 87: |
| | | | | | |
| | |} | | |} |
| − |
| |
| − | <div align="left">[[Image:calci1.gif]]</div></div>
| |
| − | ----
| |
| − | <div id="4SpaceContent" class="zcontent" align="left">
| |
| | | | |
| | '''Let's see an example in Column1Row1''' | | '''Let's see an example in Column1Row1''' |
| Line 126: |
Line 92: |
| | I.e.=ADDRESS(4,3) is TABLE3!$C$4 | | 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" | | {| id="TABLE4" class="SpreadSheet blue" |
| Line 181: |
Line 139: |
| | |} | | |} |
| | | | |
| − | <div align="left">[[Image:calci1.gif]]</div></div>
| + | =ADDRESS(4,3,2) is TABLE3!C$4) |
| − | ----
| |
| − | <div id="12SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | <nowiki>=ADDRESS(4,3,2) is TABLE3!C$4)</nowiki>
| |
| − | | |
| − | </div>
| |
| − | ----
| |