O'Reilly logo

Master VISUALLY® Excel® 2010 by Elaine Marmel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required