Changing a Formula to Show the work

**Casey_D** · 02-15-2009, 12:40 PM

I'm using microsoft office 2007 and I am making a spreadsheet to show earthwork calculations. I need to show the formula steps as well as the results

example:
A1=10 B1= 5 x 10 C1= results A1*A2
A2=5

is this possible for excel to actually show the math steps involved? not just A1*A2 or =SUM(A1*A2)

Thanks for Any help

**DonkeyOte** · 02-15-2009, 12:44 PM

Not AFAIK but you can make use of the Evaluate Formula tool and Step through the formula to see how it is calculated
(feature can be found on "Formulas" tab on 2007 Ribbon)

**Casey_D** · 02-15-2009, 01:19 PM

Thank you Donkey for your reply.

I have played around with evaluate formula (the step in- step out options) this will show how the formula is calculated but does not show these steps on the actual spreadsheet.

I am inputting many different sets of values on separate sheets. I need to print them and hand them into my prof. He requires that I show the math work involved. I was kinda hoping to make a template pump in the values and it does it all for me.

I attached a copy if it will help.

**shg** · 02-15-2009, 01:34 PM

Excel's not going to do that for you. Maple, Mathematica, or some other math engine, perhaps. The incremental formula evaluation method available via the toolbar doesn't have a VBA analog.