Excel Functions

Excel FORMULATEXT Function

Pinterest LinkedIn Tumblr

The Excel  FORMULATEXT function helps you get a formula in text form from the referred cell. This function is categorized under Excel Lookup and Reference functions.


Purpose of Excel FORMULATEXT Function

The FORMULATEXT function can be used in troubleshooting and auditing.

Return value

FORMULATEXT returns a formula as a string.


= FORMULATEXT(reference)


referenceReference to cell or cell range. Mandatory

Usage notes

  • #N/A-Occurs if the supplied cell reference:
  • Relates to a cell that does not contain a formula
  • orRelates to a cell whose formula is more than 8192 characters long
  • orRelates to a cell whose formula cannot be viewed (for example if it is protected .
  • orRelates to a cell in a workbook that is not currently open in Excel.
  • #VALUE!-Occurs if the supplied reference is not a valid cell reference.
  • The FORMULATEXT function returns what is displayed in the formula bar if you select the referenced cell.
  • Remember that you can temporarily display all formulas in a worksheet with a keyboard shortcut.
  • If the Reference argument is to an entire row or column, or to a range or defined name containing more than one cell, FORMULATEXT returns the value in the upper leftmost cell of the row, column, or range.


Since 2013 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment