Skip to content

FORMULATEXT

Lookup & referenceExcel 2016

Show the formula in a cell as text — useful for documentation.

Syntax

FORMULATEXT(reference)

Examples

=FORMULATEXT(B2)

→ "=SUM(A1:A10)"

Related functions

ISFORMULA

More Lookup & reference functions

ADDRESSAREASCHOOSECOLUMNCOLUMNSGETPIVOTDATAHLOOKUPHYPERLINKINDEXINDIRECTLOOKUPMATCH

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.