Working with logical and information functions
In this chapter, you will:
Add logical tests to your formulas with the
Perform multiple logical tests with nested
IF()functions and the
Create powerful formulas that combine logical tests with arrays
Interrogate Excel using the information functions
Count blanks, errors, and similar value with Excel’s IS functions
I mentioned in Chapter 4, “Understanding functions,” that one of the advantages of using Excel’s worksheet functions is that they enable you to build formulas that perform actions that are simply not possible with the standard operators and operands.
This idea becomes readily apparent when you learn about functions that can add intelligence ...