writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 5:
Line 5: − >where RN''' '''is the row number ,CN is the column number to use in the cell reference.+ Line 42:
Line 42: − − {| 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)
Manuals/calci/ADDRESS (view source)
Revision as of 10:54, 12 November 2013
, 10:54, 12 November 2013no edit summary
This function generates a cell address as text, given specified row and column numbers. '''ADDRESS(RN,CN,AN,A1,CText)'''
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.
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.