Ask Your Question
0

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
1

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

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

edit flag offensive delete link more

Comments

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

Stats

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

Seen: 66 times

Last updated: Jun 02 '19