Display formula with values referenced
 

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?

Display formula with values referenced
 

I think this can only be done using VBA...

"kdags" wrote:

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?

Display formula with values referenced
 

if your equation stays constant, you can use this

=D10 &" - "&D10&" ="

this will show up as 33 - 33 =

You can add more using & sign


"kdags" wrote:

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?

Display formula with values referenced
 

Thank you. That's exactly what I was looking for.

"Raz" wrote:

if your equation stays constant, you can use this

=D10 &" - "&D10&" ="

this will show up as 33 - 33 =

You can add more using & sign


"kdags" wrote:

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?