deepcalc
DocsFORMULATEXT

FORMULATEXT

View as markdown/docs/functions/formulatext.md Ask Claude about this pageOpens Claude with this page's address

Returns formula as a text string.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Text

Examples

=FORMULATEXT(Z1)
Z
1 =SUM(A1:A2)
Result =SUM(A1:A2)

Syntax

FORMULATEXT(reference)
reference
range required
CELLInformation about a cell's formatting, location or contents. ERROR.TYPEReturns number corresponding to an error type. INFOInformation about the operating environment. ISBLANKReturns TRUE if value is blank. ISDATETrue when a value can be read as a date. ISEMAILTrue when text looks like an email address.