FORMULATEXT (display formula contained in cell)

<< Click to Display Table of Contents >>

FORMULATEXT (display formula contained in cell)

Syntax:

FORMULATEXT(Cell)

Description:

Displays the formula that the specified cell contains.

Compatibility notes:

Microsoft Excel supports this function only in version 2013 or later. In older versions, the function is unknown.

Example:

If the cell A1 contains the formula =SUM(D2:D4), then FORMULATEXT(A1) will return the text "=SUM(D2:D4)".

See also:

ISFORMULA