We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calc: How show formulas next to values

asked 2019-06-02 02:42:30 +0200

catbill gravatar image

updated 2019-06-02 06:10:24 +0200

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-06-02 03:31:00 +0200

updated 2019-06-02 03:31:37 +0200

Want to see the formula in another column?

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


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

edit flag offensive delete link more


Thank you for a quick answer that is clearly explained.

catbill gravatar imagecatbill ( 2019-06-02 06:15:03 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-02 02:42:30 +0200

Seen: 145 times

Last updated: Jun 02 '19