Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell)
 

Is this even possible?

I have the following:

A1 =A2 (Shows result of 10)
A2 10
A3
A4 =A5 (Shows Result of 2)
A5 2

A7 =10+2 (Shows result of 27)

Is there a way to show the formula in A7 as =10+2 instead of having it
=A2+A5 ??? Thanks a bunch!

Show actual values added instead of cell references? (=A1+A4shows as =10+2 in cell)
 

On Dec 29, 1:24*pm, Naji wrote:
Is this even possible?

I have the following:

A1 *=A2 (Shows result of 10)
A2 *10
A3
A4 =A5 (Shows Result of 2)
A5 2

A7 =10+2 (Shows result of 27)

Is there a way to show the formula in A7 as =10+2 instead of having it
=A2+A5 ??? Thanks a bunch!

I know this is possible by highlighting the A2 and pushing F9 then
highlighting the A5 portion of the formula and pushing F9...but is
there a way to do this via formula or vba?

Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell)
 

Check one of your other posts.

Naji wrote:

On Dec 29, 1:24 pm, Naji wrote:
Is this even possible?

I have the following:

A1 =A2 (Shows result of 10)
A2 10
A3
A4 =A5 (Shows Result of 2)
A5 2

A7 =10+2 (Shows result of 27)

Is there a way to show the formula in A7 as =10+2 instead of having it
=A2+A5 ??? Thanks a bunch!

I know this is possible by highlighting the A2 and pushing F9 then
highlighting the A5 portion of the formula and pushing F9...but is
there a way to do this via formula or vba?

--

Dave Peterson

Show actual values added instead of cell references? (=A1+A4shows as =10+2 in cell)
 

On Dec 29, 2:26*pm, Dave Peterson wrote:
Check one of your other posts.



Naji wrote:

On Dec 29, 1:24 pm, Naji wrote:
Is this even possible?

I have the following:

A1 *=A2 (Shows result of 10)
A2 *10
A3
A4 =A5 (Shows Result of 2)
A5 2

A7 =10+2 (Shows result of 27)

Is there a way to show the formula in A7 as =10+2 instead of having it
=A2+A5 ??? Thanks a bunch!

I know this is possible by highlighting the A2 and pushing F9 then
highlighting the A5 portion of the formula and pushing F9...but is
there a way to do this via formula or vba?

--

Dave Peterson

Thanks. No more double posting. But which post are you referring to?

Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell)
 

No idea which of the several has the good response.



Naji wrote:

On Dec 29, 2:26 pm, Dave Peterson wrote:
Check one of your other posts.



Naji wrote:

On Dec 29, 1:24 pm, Naji wrote:
Is this even possible?

I have the following:

A1 =A2 (Shows result of 10)
A2 10
A3
A4 =A5 (Shows Result of 2)
A5 2

A7 =10+2 (Shows result of 27)

Is there a way to show the formula in A7 as =10+2 instead of having it
=A2+A5 ??? Thanks a bunch!

I know this is possible by highlighting the A2 and pushing F9 then
highlighting the A5 portion of the formula and pushing F9...but is
there a way to do this via formula or vba?

--

Dave Peterson

Thanks. No more double posting. But which post are you referring to?

--

Dave Peterson

Show actual values added instead of cell references? (=A1+A4shows as =10+2 in cell)
 

On Dec 29, 3:06*pm, Dave Peterson wrote:
No idea which of the several has the good response.



Naji wrote:

On Dec 29, 2:26 pm, Dave Peterson wrote:
Check one of your other posts.

Naji wrote:

On Dec 29, 1:24 pm, Naji wrote:
Is this even possible?

I have the following:

A1 *=A2 (Shows result of 10)
A2 *10
A3
A4 =A5 (Shows Result of 2)
A5 2

A7 =10+2 (Shows result of 27)

Is there a way to show the formula in A7 as =10+2 instead of having it
=A2+A5 ??? Thanks a bunch!

I know this is possible by highlighting the A2 and pushing F9 then
highlighting the A5 portion of the formula and pushing F9...but is
there a way to do this via formula or vba?

--

Dave Peterson

Thanks. No more double posting. But which post are you referring to?

--

Dave Peterson

I suppose this is not possible to achieve. Oh well. Thanks.

Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell)
 

The post I read sounded like they either had a suggestion or came to that same
conclusion.

I didn't go looking through all the forums you could have posted to.

My response would have been that it's possible if the formulas are pretty
simple. As soon as they get just a little more complex than real simple, it
becomes very, very difficult.

Naji wrote:

On Dec 29, 3:06 pm, Dave Peterson wrote:
No idea which of the several has the good response.



Naji wrote:

On Dec 29, 2:26 pm, Dave Peterson wrote:
Check one of your other posts.

Naji wrote:

On Dec 29, 1:24 pm, Naji wrote:
Is this even possible?

I have the following:

A1 =A2 (Shows result of 10)
A2 10
A3
A4 =A5 (Shows Result of 2)
A5 2

A7 =10+2 (Shows result of 27)

Is there a way to show the formula in A7 as =10+2 instead of having it
=A2+A5 ??? Thanks a bunch!

I know this is possible by highlighting the A2 and pushing F9 then
highlighting the A5 portion of the formula and pushing F9...but is
there a way to do this via formula or vba?

--

Dave Peterson

Thanks. No more double posting. But which post are you referring to?

--

Dave Peterson

I suppose this is not possible to achieve. Oh well. Thanks.

--

Dave Peterson