Excel functions / Lookup
FORMULATEXT function
Shows the formula in a cell as text.
Syntax
=FORMULATEXT(reference)
Arguments
reference: The cell whose formula to show.
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
The formula beside its result
A B C D E 1 Qty Price Total 2 2 5 =A2*B2 =A2*B2 In E2:
=FORMULATEXT(C2)→ =A2*B2A cell without a formula
A B C D E 1 Qty Price Total 2 2 5 10 #N/A In E2:
=FORMULATEXT(C2)→ #N/A
Common mistakes
- Typed values. A cell without a formula gives #N/A. Wrap it in IFNA to show something else.
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.
- Czech: FORMULATEXT
- Danish: FORMELTEKST
- Dutch: FORMULETEKST
- Finnish: KAAVA.TEKSTI
- French: FORMULETEXTE
- German: FORMELTEXT
- Hungarian: KÉPLETSZÖVEG
- Italian: TESTO.FORMULA
- Norwegian: FORMELTEKST
- Polish: FORMUŁA.TEKST
- Portuguese (Brazil): FÓRMULATEXTO
- Portuguese (Portugal): FÓRMULA.TEXTO
- Russian: Ф.ТЕКСТ
- Spanish: FORMULATEXTO
- Swedish: FORMELTEXT
- Turkish: FORMÜLMETNİ
Try FORMULATEXT in the playground