FORMULATEXT

FORMULATEXT(reference)

Returns the formula from a particular cell.

reference

The cell or range reference.

REMARKS

* Added in Excel 2013.
* If "reference" does not contain a formula, then #N/A is returned.
* If "reference" > 8192 characters, then #N/A is returned.
* If "reference" contains an external reference that cannot be opened, then #N/A is returned.
* If "reference" refers to a workbook that is not open, then #N/A is returned.
* The "reference" can refer to another worksheet or workbook.
* You can use the shortcut key (Ctrl + ') to quickly toggle the display of formulas.
* You can use the ISFORMULA function to return True or False if a particular cell contains a formula.
* For the Microsoft documentation refer to support.microsoft.com

	A	B
1	=FORMULATEXT(C4) = SUM(C1:C3)	5
2	=FORMULATEXT(A2) = FORMULATEXT(A2)	10
3	=FORMULATEXT(#REF!) = #REF!	15
4	=FORMULATEXT(B1) = #N/A	=SUM(B1:B3) = 30