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?
First time here? Check out the FAQ!
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.
Asked: 2019-06-02 02:42:30 +0100
Seen: 112 times
Last updated: Jun 02 '19
To display two cells contents together in another cell [closed]
Displaying formulas from horizontal block of cells to vertical block of cells [closed]
Calc cells shows only formula and not product/output [closed]
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]