display calculation steps - not final answer

  • Thread starter Thread starter skwiff
  • Start date Start date
S

skwiff

I have a spreadsheet which adds up the numbers in a column.

I would like excel to show the steps of the calculation, eg, 1+2+3.
Rather than the final answer, 6, or the formula: A1+A2+A3.

Is this possible?
 
1+2+3 is a text string which you can insert into a cell if you wish to do
so.
You could also use the formula =A1&"+"&A2&"+"&A3
 
Thanks - second option is perfect.

David Biddulph said:
1+2+3 is a text string which you can insert into a cell if you wish to do
so.
You could also use the formula =A1&"+"&A2&"+"&A3
--
David Biddulph




.
Click to expand...
 
Back
Top