Chapter 17. 17 Analyzing Formulas and Functions

Understanding Excel Errors

Chapter 15 describes the functions you can use to trap errors that Excel returns. However, you can accidentally create errors that may not be apparent. This chapter describes errors that can occur and techniques you can use to find them.

Mismatched Parentheses

Every left parenthesis must have a corresponding right parenthesis. If you try to enter a formula and you do not match all parentheses, Excel usually displays a message telling you that your formula is missing a parenthesis, and you typically need to correct the error to store the formula. However, under some circumstances, Excel corrects the error for you. For example, if you type =SUM(C1:C10 and then press Enter, forgetting ...

Get Master VISUALLY® Excel® 2010 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.