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 23:17, 3 August 2018
249 bytes added
,
23:17, 3 August 2018
no edit summary
Line 1:
Line 1:
'''ADDRESS (RowNumber,ColumnNumber,AbsoluteOption,ReferenceStyle,TableName)'''
'''ADDRESS (RowNumber,ColumnNumber,AbsoluteOption,ReferenceStyle,TableName)'''
−
*RowNumber is the row number
+
<div style="font-size:30px">'''ADDRESS (RowNumber,ColumnNumber,AbsoluteOption,ReferenceStyle,TableName)'''</div><br/>
−
*ColumnNumber is the column number
+
−
*AbsoluteOption
specifies
the type of reference to return
+
*
<math>
RowNumber
</math>
is the row number
−
*ReferenceStyle is the logical value
+
*
<math>
ColumnNumber
</math>
is the column number
−
*TableName is the name of the Calci worksheet to be used as the external reference.
+
*
<math>
AbsoluteOption
</math>
the type of reference to return
+
*
<math>
ReferenceStyle
</math>
is the logical value
+
*
<math>
TableName
</math>
is the name of the Calci worksheet to be used as the external reference.
+
**ADDRESS(), returns a reference as text to a single cell in a worksheet.
+
==Description==
==Description==
Devika
writer
6,694
edits