CellReferenceA1Style
[this page | pdf]
Function Description
Returns text corresponding to a reference to an individual
cell, in A1 style.
CellRow and CellCol define the cell itself
(e.g. CellRow = 3 and CellCol = 2 corresponds to B3). If FrozenRows
is true then the formula created by this function includes absolute row cell
references, e.g. B$3, whereas if FrozenRows is false then it creates
relative row cell references, e.g. B3. FrozenCols does the same but for
column cell references, e.g. $B3 versus B3.
NAVIGATION LINKS
Contents | Prev | Next
Output type / Parameter details
Output type: String
Parameter Name | Variable Type | Description |
CellRow | Integer | Row of cell |
CellCol | Integer | Column of cell |
FrozenRow | Boolean | If true formula uses absolute row cell references, else relative ones |
FrozenCol | Boolean | If true formula uses absolute column cell references, else relative ones |
Links to:
-
Interactively run function
-
Interactive instructions
-
Example calculation
-
Output type / Parameter details
-
Illustrative spreadsheet
-
Other General functions
-
Computation units used
Note: If you use any Nematrian web service either programmatically or interactively then you will be deemed to have agreed to the Nematrian website License Agreement