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
=FORMULA(A8) returns the text
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.
Thank you for a quick answer that is clearly explained.