Chapter 6

Working with logical and information functions

In this chapter, you will:

  • Add logical tests to your formulas with the IF() function

  • Perform multiple logical tests with nested IF() functions and the AND() and OR() functions

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

Get Microsoft Excel 2019 Formulas and Functions, First Edition now with the O’Reilly learning platform.

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