Open main menu
Home
Random
Log in
Settings
About ZCubes Wiki
Disclaimers
ZCubes Wiki
Search
Changes
← 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