writer
6,694
edits
Changes
no edit summary
'''ADDRESS (RowNumber,ColumnNumber,AbsoluteOption,ReferenceStyle,TableName)'''
<div style="font-size:25px">'''ADDRESS (RowNumber,ColumnNumber,AbsoluteOption,ReferenceStyle,TableName)'''</div><br/>
*RowNumber is the row number
*ColumnNumber is the column number
*<math>RowNumber</math> is the row number
*AbsoluteOption specifies the type of reference to return
*<math>ColumnNumber</math> is the column number
*ReferenceStyle is the logical value
*<math>AbsoluteOption</math> the type of reference to return
*TableName is the name of the Calci worksheet to be used as the external reference.
*<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==
*=ADDRESS(2,3,4) : Table1!C2
*=ADDRESS(2,3,4) : Table1!C2
*=ADDRESS(2,3,4,"FALSE","CALCI") : CALCI!C2
*=ADDRESS(2,3,4,"FALSE","CALCI") : CALCI!C2
==Related Videos==
{{#ev:youtube|nydCUYe00cU|280|center|ADDRESS}}
==See Also==
==See Also==
==References==
==References==
*[https://support.office.com/en-sg/article/ADDRESS-function-47657e92-81ae-47f8-87cd-62d4f30c774d?ui=en-US&rs=en-SG&ad=SG Address]
*[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 ]]