Excel Formula Display in Cell

Closed
Sim - May 26, 2010 at 01:24 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- May 26, 2010 at 02:58 AM
Hello,

I hope someone can help me.

I need to print the step by step values of a formula in a cell

for example ilets say: cells(A,3)= Cells (A,1) + Cells (A,2)
If cells(A,1) = 5 and Cells(A,2) = 3
I need to print in Cells(A,3) :"=5+3=8"

I know this is possible but i dont know how

Thanks


1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 26, 2010 at 02:58 AM
You meant some thing like this

= "= " & A1 & " + " & A2 & " = " & A3
0