Difference between revisions of "Manuals/calci/ADDRESS"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | + | <div style="font-size:30px">'''ADDRESS(RN,CN,AN,A1,CText)'''</div><br/> | |
| + | *RN is the row number | ||
| + | *CN is the column number | ||
| + | *AN specifies the type of reference to return | ||
| + | *A1 is the logical value | ||
| + | *CText is the name of the calci worksheet to be used as the external reference. | ||
==Description== | ==Description== | ||
| + | *This function generates a cell address as text, given specified row and column numbers. | ||
| − | |||
| − | |||
| − | |||
{|style="width:50%; height:100px" border="1" | {|style="width:50%; height:100px" border="1" | ||
|- | |- | ||
Revision as of 05:48, 12 November 2013
ADDRESS(RN,CN,AN,A1,CText)
- RN is the row number
- CN is the column number
- AN specifies the type of reference to return
- A1 is the logical value
- CText 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.