Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
When one cell references another that contains a formula, only the value is displayed. Is there a way to display the actual text of the formula in this second cell?
Here's a simulated version of what I'm trying to achieve:
Cell A4 contains the SUM formula. Cell B4 displays the text that makes up the formula in cell A4.
Yes, there is a way, actually there are more than one. Here is one from Google Sheets Function List
| Type | Name | Syntax | Description |
|---|---|---|---|
| Lookup | FORMULATEXT | FORMULATEXT(cell) | Returns the formula as a string. Learn more |
