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

Excel Formula Display in Cell
Date formula in excel dd/mm/yyyy - Guide
Number to words in excel formula - Guide
Excel grade formula - Guide
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
Excel formula to subtract one cell from another - Excel Forum

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

Similar discussions

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

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

If a cell contains any text then add a value

Similar discussions

Subscribe To Our Newsletter!