Excel Function : FORMULATEXT
Category
Lookup and reference
Description
Returns the formula at the given reference as text
Microsoft Excel Reference Page
https://support.office.com/en-us/article/FORMULATEXT-function-0a786771-54fd-4ae2-96ee-09cda35439c8
Syntax and Description of the FORMULATEXT Excel Function
The syntax for the FORMULATEXT function in Microsoft Excel is: FORMULATEXT( reference ) Reference is a cell reference. The FORMULATEXT function returns the formula in a cell as text.
About FORMULATEXT Excel Function
The FORMULATEXT function returns a string that represents the formula in a cell. For example, if cell A1 contains the formula =B1+C1, the formula in A1 is returned as =B1+C1.