Difference between revisions of "Manuals/calci/ADDRESS"
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=...") |
|||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | + | ==Description== | |
| − | |||
| − | |||
| − | + | This function generates a cell address as text, given specified row and column numbers. '''ADDRESS(RN,CN,AN,A1,CText)''' | |
| − | + | >where RN''' '''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. | ||
| − | |||
| − | |||
| − | |||
{| width="297" cellpadding="2" | {| width="297" cellpadding="2" | ||
| Line 63: | Line 38: | ||
|} | |} | ||
| − | |||
'''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. | ||
| − | |||
| − | |||
| − | |||
| − | |||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
| Line 117: | Line 87: | ||
| | | | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
'''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 | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| id="TABLE4" class="SpreadSheet blue" | {| id="TABLE4" class="SpreadSheet blue" | ||
| Line 181: | Line 139: | ||
|} | |} | ||
| − | + | =ADDRESS(4,3,2) is TABLE3!C$4) | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 05:53, 12 November 2013
Description
This function generates a cell address as text, given specified row and column numbers. ADDRESS(RN,CN,AN,A1,CText)
>where RN is the row number ,CN is the column number to use in the cell reference.
AN specifies the type of reference to return.
|
AN |
types of reference |
|
1 or omitted |
Absolute |
|
2 |
Absolute row,relative column |
|
3 |
Relative row,absolute column |
|
4 |
Relative |
A1 is a logical value
CText is text specifying the name of the calcisheet to be used as the external reference.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | TABLE3!$C$4 | |||
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
Let's see an example in Column1Row1
I.e.=ADDRESS(4,3) is TABLE3!$C$4
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | TABLE4!C$4 | |||
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
=ADDRESS(4,3,2) is TABLE3!C$4)