FORMULATEXT function

The FORMULATEXT function returns a formula as a string. 

Parts of a FORMULATEXT function 

FORMULATEXT(cell) 

Part	Description
cell	The cell to be verified as containing a formula.

Notes

• FORMULATEXT returns what is displayed in the formula bar when selecting a cell.
• If the cell passed into FORMULATEXT references the cell that contains the FORMULATEXT formula, then FORMULATEXT will properly handle this and avoid a circular reference.
• If a range is passed into FORMULATEXT , only the top left most cell is evaluated.

Examples 

	A	B	C
1	Value	Formula	Result
2	20	=FORMULATEXT($A2)	=10+10
3	18	=FORMULATEXT($A3)	=MAX(10,12,18)
4	10	=FORMULATEXT($A4:$A5)	=MODE.MULT(10,15,10,15)
5	15	=FORMULATEXT($A4:$A5)	=MODE.MULT(10,15,10,15)
6	=FORMULATEXT($A6)	=FORMULATEXT($A6)	=B6