writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: + + + + + + + + − + − − − 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. − Line 28:
Line 30: + + + + + + + + + + − '''A1''' is a logical value+ + + + + + + + + + + + + + + + + − CText is text specifying the name of the calcisheet to be used as the external reference.+
no edit summary
<div style="font-size:25px">'''ADDRESS (RowNumber,ColumnNumber,AbsoluteOption,ReferenceStyle,TableName)'''</div><br/>
*<math>RowNumber</math> is the row number
*<math>ColumnNumber</math> is the column number
*<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==
*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)'''
{|style="width:50%; height:100px" border="1"
{|style="width:50%; height:100px" border="1"
|}
|}
'''A1''' is a logical value
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
==Related Videos==
{{#ev:youtube|nydCUYe00cU|280|center|ADDRESS}}
==See Also==
*[[Manuals/calci/COLUMN | COLUMN]]
*[[Manuals/calci/COLUMNS | COLUMNS]]
*[[Manuals/calci/ROW | ROW]]
*[[Manuals/calci/CELL | CELL]]
==References==
*[https://support.office.com/en-sg/article/ADDRESS-function-47657e92-81ae-47f8-87cd-62d4f30c774d?ui=en-US&rs=en-SG&ad=SG Address]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]