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
Was this helpful?
How can we improve it?