Previous Topic Next Topic

Excel Formula Display in Cell

Closed
Sim - May 26, 2010 at 01:24 AM
rizvisa1 Posts 4478 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


Related:

1 response

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

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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response
Formula to subtract one cell value from another.
autigers71 -
vcoolio -

1 response