Difference between revisions of "Manuals/calci/ADDRESS"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''ADDRESS( | + | <div style="font-size:30px">'''ADDRESS (RowNumber,ColumnNumber,AbsoluteOption,ReferenceStyle,TableName)'''</div><br/> |
| − | * | + | *RowNumber is the row number |
| − | * | + | *ColumnNumber is the column number |
| − | * | + | *AbsoluteOption specifies the type of reference to return |
| − | * | + | *ReferenceStyle is the logical value |
| − | * | + | *TableName is the name of the Calci worksheet to be used as the external reference. |
==Description== | ==Description== | ||
Revision as of 00:26, 2 April 2014
ADDRESS (RowNumber,ColumnNumber,AbsoluteOption,ReferenceStyle,TableName)
- RowNumber is the row number
- ColumnNumber is the column number
- AbsoluteOption specifies the type of reference to return
- ReferenceStyle is the logical value
- TableName 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.