| Syntax |
| FORMULATEXT(reference) |
| Purpose / Description |
| returns a text string that displays the formula for the referenced cell. |
| Arguments |
| Name |
Type |
Description |
| reference |
reference |
A reference or a nested expression that returns a reference to a cell, whose formula is to be displayed as a text string. |
| Return Values |
| Type |
Specific Value |
Description |
| text string |
|
A text string that displays the formula in the referenced cell, provided it contains a formula. |
| error |
#N/A |
If the reference argument is a reference to a blank cell, or a cell containing a constant value. |
| error |
|
Any errors referenced by arguments are returned due to propagation of error values. |
| Notes / Comments / Advice / Warnings |
| Note: |
If this function references the cell in which it is stored, it returns the text of the formula, it does not generate a circular reference, since the cell's value is not dependent upon its own value, but the text of the formula it contains |
| Comment: |
Most of the sample files for the function references contain the FORMULATEXT function as part of the formula that shows the various formulas in demonstrating the workings of those functions. |
| Examples: |
Open / download sample workbook: FORMULATEXT.xlsx |
| |