This function returns a formula as a string.
FORMULATEXT(reference)
Specify the reference to single cell or range of cells for the argument.
In this function, text displayed in the formula bar of the specified cell is returned. Reference argument can refer to cell (or cells) of another worksheet or workbook too. Value of upper leftmost cell or row is returned, if an entire row or column is refered.
Accepts cell reference for argument. Returns string data.
FORMULATEXT(B7) gives the value #N/A