FORMULATEXT

Purpose

  • Returns a cell's formula text as a text string

Example

FORMULATEXT

  • Here is a screenshot, for reference:

FORMULATEXT

  • Notice that two cells do not contain formulas (i.e. they do not begin with the "=" symbol)
  • One way around this is to nest FORMULATEXT in the IFERROR function, as shown in this screenshot:

FORMULATEXT


Syntax

  • =FORMULATEXT(reference)

Arguments

  • reference
    • This is a reference to the cell containing the formula (and you want to see the syntax of that formula)

External Links