FORMULA_TEXT

Returns the formula in the referenced cell as a text string.

This is useful for annotating worksheets, displaying and printing out the formula which created the results shown in the worksheet.

Syntax:

FORMULA_TEXT(cell_reference)

Revisions:

Starting with 2.00, this function takes notice of the Alternate formula style choice.

If set, this choice outputs a string with an initial equal sign, upper-case function names and cell references and cell references in ranges are given with a colon separator.