Use Excel FORMULATEXT Function to get a formula from a cell as a text string.
In simple words, when you refer to a cell which contains a formula, it will return that formula from the cell, like which is displayed in the formula bar if you select that referred cell.
reference A cell reference from which you want formula as a text.
More Information on Excel FORMULATEXT Function
- You can refer to another workbook & another worksheet.
- If you refer to another workbook that workbook should be open, otherwise it will not show the formula.
- If you refer to a range more than a single cell, it will return formula from the upper left cell of the given range.
- It will return an “#N/A” error value if the cell you are using as a reference does not contain any formula, has a formula with more than 8192 characters, a cell is protected or an external workbook is not opened.
- If you refer two cells in circular reference it will return result from both.
In the below example, I have used formula text with a different type of references. When you refer to a cell which doesn’t have any formula, it will return “#N/A” error value.
To learn more about Excel FORMULATEXT Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.