Difference between revisions of "Manuals/calci/ADDRESS"
Jump to navigation
Jump to search
| (14 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. | ||
| − | + | {|style="width:50%; height:100px" border="1" | |
| − | + | |- | |
| − | + | !AN | |
| − | + | !Types of reference | |
| − | + | |- | |
| − | |||
| − | |||
| − | {| | ||
| − | |- | ||
| − | |||
| − | |||
| − | |- | ||
|1 or omitted | |1 or omitted | ||
|Absolute | |Absolute | ||
| − | |- | + | |- |
|2 | |2 | ||
|Absolute row,relative column | |Absolute row,relative column | ||
| Line 23: | Line 25: | ||
|3 | |3 | ||
|Relative row,absolute column | |Relative row,absolute column | ||
| − | |- | + | |- |
|4 | |4 | ||
|Relative | |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== | |
| + | |||
| + | {{#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 17: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.
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.
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