K
kdags
I want to display a formula where values are referenced from other cells.
For example:
Column D displays the result of A-B. I want C to automatically display the
actual formula with the referenced values, not the cell numbers.
A B C D
1 10 7 10 - 7 = =A1-B1
"3"
2 20 12 20 - 12 = =A2-B2
"8"
Is there a way to do this?
For example:
Column D displays the result of A-B. I want C to automatically display the
actual formula with the referenced values, not the cell numbers.
A B C D
1 10 7 10 - 7 = =A1-B1
"3"
2 20 12 20 - 12 = =A2-B2
"8"
Is there a way to do this?