O'Reilly logo

Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables, 4th Edition by Paul McFedries

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 2

Troubleshooting Formulas

Understanding Error Values in Excel

Excel formula errors fall into three main categories. First, there are the syntax errors, where Excel generates an error message when you press Enter to accept the formula. For example, if you forget a function’s closing parenthesis, Excel displays an error letting you know that the parenthesis is missing. Next, there are the inaccuracy errors, where your worksheet data is wrong, one or more operators or operands in your formula are wrong, or both. Finally, there are the errors where Excel cannot compute a formula result and, instead, displays an error value. Excel has seven different error values — #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!.

#DIV/0!

The

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