Chapter 2
Logical Functions and Error Trapping
IN THIS CHAPTER
Understanding formula error values
Understanding the logical functions
Creating IF formulas that trap errors
Auditing formulas
Changing the Error Checking options
Masking error values in your printouts
Excel formulas can become quite complex and one of the iron-clad rules of spreadsheet work is that as complexity increases, so does the chance of having errors infest your work. If you're starting to see errors in your worksheets, you've come to the right place: Troubleshooting the formula errors in a worksheet is the main topic of this chapter. Here, you see how to locate the source of all those vexing formula errors so that you can shoot them down and set things right! The biggest problem with errors in your formulas — besides how ugly such values as #REF! and #DIV/0! are — is that they spread like wildfire through the ...
Get Excel All-in-One For Dummies now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
