Formulas can often be difficult in Excel. If you aren’t a math whiz, you may not recall the standard order of precedence that Excel uses. For example, within a formula, multiplication is performed before any addition or subtraction and calculations within parenthesis are performed before any others. If you do not understand how Excel is performing a calculation, you can use the Evaluate Formula option to make it clearer.

To use the Evaluate Formula option in Excel 2003:

  1. Within Excel, select the cell you want to evaluate.
  2. From the Tools menu, point to Formula Auditing and click Evaluate Formula.
  3. Click the Evaluate button to watch as Excel evaluates each step of the formula.
  4. To view the evaluation again, click Restart.

[rsslist:http://ah.pricegrabber.com/export_feeds.php?pid=hjehfab&document_type=rss&limit=25&topcat_id=all&category=topcat:all&col_description=1&form_keyword=excel+tips]