FormulaText function

Description

This FORMULATEXT function returns a formula as a text string from given reference. FORMULATEXT can be used to extract a formula as text from a cell. If the FORMULATEXT used on a cell that doesn't contain a formula, it will prompt #N/A error.

​

Objective

Obtain formula in a cell.

​

Syntax

=FORMULATEXT(reference)

​

Arguements

reference - Reference to cell or cell range.

​

​