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
 
Back
Top