Difference between revisions of "Manuals/calci/ADDRESS"
(11 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
+ | <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. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
{|style="width:50%; height:100px" border="1" | {|style="width:50%; height:100px" border="1" | ||
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. | ||
+ | |||
+ | ==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 ]] |
Latest revision as of 18:18, 3 August 2018
ADDRESS (RowNumber,ColumnNumber,AbsoluteOption,ReferenceStyle,TableName)
- is the row number
- is the column number
- the type of reference to return
- is the logical value
- 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
- This function generates a cell address as text, given specified row and column numbers.
AN | Types of reference |
---|---|
1 or omitted | Absolute |
2 | Absolute row,relative column |
3 | Relative row,absolute column |
4 | Relative |
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
See Also
References