/

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


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


Desktop view | Switch to Mobile