FORMULATEXT function returns a text string from given reference containing a formula.
The function has the following argument in the syntax:
(reference) – Required. The reference to a cell/ range of cells, containing a formula.
|The FORMULATEXT function is used on a reference that does not contain a formula.|
|The reference argument is from another workbook that is not open.|
|The formula in the cell is more than 8192 characters long.|
|The worksheet having reference argument is protected.|
|VALUE!||If invalid cell reference is provided.|
For more detail, visit Microsoft Excel website.