Microsoft Office Tutorials and References
In Depth Information
Evaluate a Nested Formula One Step at a Time
To see the evaluation again, click Restart .
Some parts of formulas that use IF and CHOOSE functions are not evaluated,
and #NA is displayed. If a reference is blank, a zero value (0) is displayed.
Some functions recalculate each time the worksheet changes, and can
cause the Evaluate Formula to display different results. These functions
include RAND, AREAS, INDEX, OFFSET, CELL, INDIRECT, ROWS,
COLUMNS, NOW, TODAY, AND RANDBETWEEN.