FORMULA_TEXT

Syntax:

FORMULA_TEXT(cell_reference)

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

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

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.