Evaluating Formulas  

You can evaluate formulas in Microsoft Excel. The little formula auditing tool has some interesting capabilities.


3. Consider This: Evaluate a Formula

In the example on this page, the formula refers to several cells that are calculated in a different spreadsheet. When a cell reference, such as Cell H11, is highlighted, you can Step Into the cell and look at the formula that goes with it.

Way cool technology.

Formulas ->Formula Auditing->Evaluate Formula

Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.2. Enforce precedence: Order of Evaluation