Formulas and functions > Functions from A to Z > FORMULATEXT (display formula contained in cell)

Syntax:

FORMULATEXT(Cell)

Description:

This displays the formula that is in the specified cell.

Compatibility notes:

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

Example:

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