Changes
Jump to navigation
Jump to search
← Older edit
Newer edit →
Manuals/calci/ADDRESS
(view source)
Revision as of 06:47, 2 April 2014
206 bytes added
,
06:47, 2 April 2014
no edit summary
Line 29:
Line 29:
'''A1''' is a logical value
'''A1''' is a logical value
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.
+
+
==Examples==
+
*=ADDRESS(2,3) : Table1!$C$2
+
*=ADDRESS(2,3,1) : Table1!$C$2
+
*=ADDRESS(2,3,2) : Table1!C$2
+
*=ADDRESS(2,3,3) : Table1!$C2
+
*=ADDRESS(2,3,4) : Table1!C2
+
*=ADDRESS(2,3,4,"FALSE","CALCI") :CALCI!C2
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