Stepping through calculations

F

Frank

Is there a way to step through a calculation. For
example, if I have the formula =10+15-5, is ther a way to
go through it step by step. That is, is there a way to
see: 10+15=25 > 25-5=20. This would be very helpful in
finding where I have made ereors in writing formulas.
 
O

Orlando Magalhães Filho

Hi Frank,

Excel 2002 (XP) has Evaluate Formula tool on the Formula Auditing toolbar.
On early Excel versions you can select each part of the formula on the
formula bar and press F9.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New computer, how do i move outlook 365 ENTIRELY? 0
Indenting every other paragraph in Word at the same time? 0
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Formula to auto calculate based on other variables 8
MS Project. Real progress of the project, % complete 1
create manufacturing demand based on customer delivery 0
Drop down list control value in vba 2

Top