Returns the contents of a cell as they would appear in the formula bar. The contents are given as text, for example, "=2*PI()/360". If the formula contains references, they are returned as R1C1-style references, such as "=RC[1]*(1+R1C1)". Use GET.FORMULA to get a formula from a cell in order to edit its arguments. Use GET.CELL(6) to get a formula in either A1 or R1C1 format, depending on the workspace setting.
Syntax
GET.FORMULA(reference)
Reference is a cell or range of cells on a sheet or macro sheet.
If a range of cells is selected, GET.FORMULA returns the contents of the upper-left cell in reference.
Reference can be an external reference.
Reference can be the object identifier of a picture created by the camera tool.
Reference can also be a reference to a chart series in the form "Sn" where n is the number of the series. When a chart series is specified, GET.FORMULA returns the series formula using R1C1-style references.
Tip If you want to get the formula in the active cell, use the ACTIVE.CELL function as the reference argument.
Examples
If cell A3 on the active sheet contains the number 523, then:
GET.FORMULA(!$A$3) equals "523"
If cell C2 on the active sheet contains the formula =B2*(1+$A$1), then:
GET.FORMULA(!$C$2) equals "=RC[-1]*(1+R1C1)"
The following macro formula returns the contents of the active cell on the active sheet:
GET.FORMULA(ACTIVE.CELL())
Related Functions
GET.CELL Returns information about the specified cell
GET.DEF Returns a name matching a definition
GET.NAME Returns the definition of a name
GET.NOTE Returns characters from a comment
Return to index