Difference between revisions of "Manuals/calci/ADDRESS"
Jump to navigation
Jump to search
| (5 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | '''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 | + | *<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== | ||
| Line 36: | Line 39: | ||
*=ADDRESS(2,3,3) : Table1!$C2 | *=ADDRESS(2,3,3) : Table1!$C2 | ||
*=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== | ||
| + | *[[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.
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