Difference between revisions of "Manuals/calci/ADDRESS"

From ZCubes Wiki
Jump to navigation Jump to search
 
(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. '''ADDRESS(RN,CN,AN,A1,CText)'''
 
 
 
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.
 
 
 
  
 
{|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
  
'''A1'''   is a logical value
+
==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]]
  
CText  is text specifying the name of the calcisheet to be used as the external reference.
+
*[[ 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

ADDRESS

See Also

References