I would like to show values in one column and show the formulas for deriving those values in an adjacent column. How do I do that?

Want to see the formula in another column?

Displays the formula of a formula cell as a text string.

Syntax

**FORMULA(Reference)**

Reference is a reference to a cell containing a formula.

An invalid reference or a reference to a cell with no formula results in the error value #N/A.

Example

If cell A8 contains the formula `=SUM(1;2;3)`

then

`=FORMULA(A8)`

returns the text `=SUM(1;2;3).`

**ATTENTION:** If you would like to give more details to your question, use **edit** in question or **add a comment** below. Thank you.

If the answer met your need, please click on the ball to the left of the answer, to finish the question.

Thank you for a quick answer that is clearly explained.