formulatext

Formula in a referenced cell as text.

Syntax

v = formulatext(reference)

Description

Returns the formula string of the cell at reference. Useful for auditing and dynamic dashboards. Returns #N/A if the cell has no formula.

Example

formulatext(A1)    % '=B1+C1'

See also

• indirect — Reference resolved from a text string.
• cell — Information about formatting, location, or contents of a cell.