Changes

Manuals/calci/ADDRESS (view source)

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==

+

*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"

|-

writer

5,435

edits