The FORMULATEXT can be used to extract a formula as text from a cell reference.
Once text is extracted with FORMULA text, it can be handled as text in another formula.
FORMULATEXT takes just one argument,reference, which is normally a cell reference like A1.
If you use FORMULATEXT on a cell that doesn’t contain a formula, it returns #N/A.
FORMULATEXT will handle formulas up to 8192 characters.
InExcel 365, the FORMULATEXT function will return more than one result when given arangethat contains formulas.
These results willspilllike otherdynamic arrayformulas.
To test whether a cell contains a formula, use theISFORMULA function.
When a cell contains a formula ISFORMULA will return TRUE regardless of the formula’s output or error conditions.
