Changes

Jump to navigation Jump to search
102 bytes added ,  11:48, 12 November 2013
no edit summary
Line 1: Line 1: −
 
+
<div style="font-size:30px">'''ADDRESS(RN,CN,AN,A1,CText)'''</div><br/>
 +
*RN is the row number
 +
*CN is the column number
 +
*AN specifies the type of reference to return
 +
*A1 is the logical value
 +
*CText is the name of the calci worksheet to be used as the external reference.
    
==Description==
 
==Description==
 +
*This function generates a cell address as text, given specified row and column numbers.
   −
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.
   
{|style="width:50%; height:100px" border="1"
 
{|style="width:50%; height:100px" border="1"
 
|-  
 
|-  
writer
5,435

edits

Navigation menu