evaluate formulas in Microsoft Excel. The little formula auditing
tool has some interesting capabilities.
Consider This: Evaluate a Formula
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.