Summary

The Excel FORMULATEXT function returns the formula in a referenced cell as text. Instead of showing the calculated result, it shows the actual formula string that Excel is using.

This is useful in audits, documentation, and model review. For example, a workbook can display its own formulas beside the outputs, or a checker sheet can test whether a formula contains a particular function name.

FORMULATEXT is not a calculation function in the usual sense. Its value is that it exposes formula logic so that the formula itself can be inspected.

Syntax

=FORMULATEXT(reference)

reference is the cell that contains the formula you want to show. If the referenced cell does not contain a formula, FORMULATEXT returns #N/A.

Because the result is text, it can be combined with functions such as SEARCH, FIND, or exact comparisons to analyze the formula itself.

Arguments

• reference - The cell or range reference whose formula you want to display.

The referenced cell must actually contain a formula. If it contains a hard-coded number or text, FORMULATEXT does not return that value; it returns an error instead.

FORMULATEXT vs Other Functions

FORMULATEXT is best understood by comparing it with functions that answer different questions about a cell.

Use FORMULATEXT when the exact formula matters. Use ISFORMULA when you only need to know whether a formula is present at all.

Using FORMULATEXT

One common use of FORMULATEXT is self-documentation. A workbook can show both the result and the formula that produced it, which helps reviewers understand the model without entering each cell individually.

Another use is consistency checking. If two cells should contain the same logic pattern, their formula text can be compared directly. If one row was overwritten with a hard-coded value, FORMULATEXT can help reveal that difference.

It can also support simple formula scanning. Because the returned formula is text, a workbook can search for terms such as OFFSET, INDIRECT, or a particular sheet name.

• Use FORMULATEXT when you need to display a formula instead of its result.
• Use it with text functions if you want to inspect the formula for keywords.
• Expect #N/A if the referenced cell does not contain a formula.

Example 1 - Standard Calculation Transparency

This formula shows the formula stored in B3 rather than the calculated result. That makes it useful in review sheets or documentation tables where the logic itself needs to be visible.

=FORMULATEXT(B3)

Example 2 - Dynamic Rule Documentation

Displaying the formula from another cell can create live documentation inside the workbook. If the source formula changes later, the displayed formula text changes too.

=FORMULATEXT(B2)

Example 3 - Automated Volatility Audit Flag

Here FORMULATEXT is wrapped in SEARCH to check whether the formula contains the word OFFSET. This is a practical example of using formula text as data that can be analyzed.

=ISNUMBER(SEARCH("OFFSET", FORMULATEXT(B1)))

Example 4 - Relative Logic Verification

Comparing two FORMULATEXT results shows whether the formulas are identical as text. This can help detect rows that no longer use the same logic pattern as the rest of the sheet.

=FORMULATEXT(A1)=FORMULATEXT(B1)

Conclusion Recap

• Summary: FORMULATEXT returns a cell's formula as text.
• Syntax: =FORMULATEXT(reference).
• Core setup: The referenced cell must contain a formula, or Excel returns #N/A.
• Best use: Audits, documentation, formula comparison, and keyword checks inside formulas.