Excel functions / Lookup

FORMULATEXT function

Shows the formula in a cell as text.

Syntax

=FORMULATEXT(reference)

Arguments

When to use it

FORMULATEXT gives the formula in a cell as text, exactly as typed. It is used to document a sheet, to teach (show the formula beside its result) and to check a model.

Examples

  1. The formula beside its result

    ABCDE
    1QtyPriceTotal
    225=A2*B2=A2*B2

    In E2: =FORMULATEXT(C2) → =A2*B2

    Try this example

  2. A cell without a formula

    ABCDE
    1QtyPriceTotal
    22510#N/A

    In E2: =FORMULATEXT(C2) → #N/A

    Try this example

Common mistakes

FORMULATEXT in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try FORMULATEXT in the playground

Related functions