Microsoft Office Tutorials and References
In Depth Information
Figure C–8. Note the legend, foretelling the error evaluation which will result when you click Evaluate….
Figure C–9. …as we now see
While the command sequence is a bit convoluted, you get the idea. Excel diagnoses the error in a couple
of clicks. Note as well that the Evaluate Formula button in the Formulas button group takes you directly
to the Evaluate Formula dialog box you see above.