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?
add a comment
We will be migrating from Ask to Discourse on the first week of August, read the details here
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.
Asked: 2019-06-02 02:42:30 +0200
Seen: 145 times
Last updated: Jun 02 '19
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
