Difference between revisions of "Manuals/calci/ADDRESS"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
This function generates a cell address as text, given specified row and column numbers. '''ADDRESS(RN,CN,AN,A1,CText)''' | 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. | AN specifies the type of reference to return. | ||
| Line 42: | Line 42: | ||
CText is text specifying the name of the calcisheet to be used as the external reference. | CText is text specifying the name of the calcisheet to be used as the external reference. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 04:54, 12 November 2013
Description
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.
|
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.