Calc: How show formulas next to values

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.


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.

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 Descrição da imagem to the left of the answer, to finish the question.

Thank you for a quick answer that is clearly explained.