FORMULATEXT Function

Description

Returns a formula as a string.

NOTE

• The function can returns the #N/A error value by the following reasons:
  • The formula in the cell is longer than 8192 characters.
  • An external workbook that contains the formula is not open in Excel.

Syntax

Copied!=FORMULATEXT(reference)
=FORMULATEXT(reference)

EXAMPLE 1

Copied!=FORMULATEXT(B3)
=FORMULATEXT(B3)

RELATED