FORMULATEXT

FORMULATEXT(reference)

Returns the formula from a particular cell.

reference

The cell or range reference.

REMARKS

* This function was 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
* For the Google documentation refer to support.google.com

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

1 - What is the formula in cell "B4".
2 - What is the formula in cell "A1".
3 - What is the formula in cell "A2".
4 - What is the formula when an error is passed in.
5 - What is the formula in a cell that does not contain a formula.