Formualizer Docs
ReferenceFunctionsInformation Functions

FORMULATEXT

FORMULATEXT: Returns the formula text stored in the referenced cell.

Summary

Retrieves formula source text for a single referenced cell without evaluating that cell's value.

Remarks

  • Returns #N/A if the reference does not point at a formula cell.
  • Staged formula text is preferred when present; otherwise canonical formula text is returned.

Returns the formula text stored in the referenced cell.

Examples

Formula text
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
=1 + 2

FAQ

Does FORMULATEXT evaluate the referenced formula?

No. It retrieves formula provenance/source text only.

Runtime metadata

Category

Information

Signature

FORMULATEXT(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/info.rs

ERROR.TYPE

ERROR.TYPE: Returns a number corresponding to an error type Returns: 1 = #NULL! 2 = #DIV/0! 3 = #VALUE! 4 = #REF! 5 = #NAME? 6 = #NUM! 7 = #N/A 8 = #GETTING_DATA (n…

ISBLANK

ISBLANK: Returns TRUE only for a truly empty value.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes FORMULATEXT evaluate the referenced formula?Runtime metadata