Changes
Jump to navigation
Jump to search
← Older edit
Newer edit →
Manuals/calci/ADDRESS
(view source)
Revision as of 11:48, 12 November 2013
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"
|-
|-
Abin
writer
5,435
edits
Navigation menu
Personal tools
Log in
Namespaces
Page
Discussion
Variants
Views
Read
View source
View history
More
Search
Navigation
Main page
Community portal
Current events
Recent changes
Help
Tools
ZCubes Web Platform
Printable version