Skip to main content

FORMULATEXT function

The FORMULATEXT function is one of the lookup and reference functions. It is used to return a formula as a string (i.e. the text string that is displayed in the formula bar if you select the cell that contains the formula).

Syntax​

FORMULATEXT(reference)

The FORMULATEXT function has the following argument:

ArgumentDescription
referenceA reference to a single cell or a range of cells.

Notes​

If the referenced cell range contains more than one formula, the FORMULATEXT function returns the value from the upper left cell of this range. If the referenced cell does not contain a formula, the FORMULATEXT function returns the N/A error value.

Please note that this is an array formula. To learn more, please read the Insert array formulas article.

How to apply the FORMULATEXT function.

Examples​

The figure below displays the result returned by the FORMULATEXT function.

FORMULATEXT Function