Stepping through calculations

  • Thread starter Thread starter Frank
  • Start date Start date
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.
 
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

Scrabble Value calculation for Welsh words 0
Formula to auto calculate based on other variables 8
Calculate the total overlapping time of multiple tasks, excluding non-working times 1
Combinations in a string of data 4
Total Time to Resolution 1
Accumulated percentage calculation 2
Stock Maintence 2
Stair-step commissions question 2

Back
Top