Changes

Manuals/calci/ADDRESS (view source)

Revision as of 10:54, 12 November 2013

1,157 bytes removed , 10:54, 12 November 2013

no edit summary

Line 5: Line 5:

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.

+

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.

Line 42: Line 42:

CText is text specifying the name of the calcisheet to be used as the external reference.

−

~~{| 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~~

−

|

−

|

−

|

−

|

−

|}

−

~~'''Let's see an example in Column1Row1'''~~

−

~~I.e.=ADDRESS(4,3) is TABLE3!$C$4~~

−

~~{| 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~~

−

|

−

|

−

|

−

|

−

|}

−

~~=ADDRESS(4,3,2) is TABLE3!C$4)~~

Abin

writer

5,435

edits