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?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false