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:

enter image description here

Cell A4 contains the SUM formula. Cell B4 displays the text that makes up the formula in cell A4.

1 Answer 1


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


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.