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 values with Excel’s IS functions

In Chapter 4, “Understanding functions,” I mentioned 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 Formulas and Functions (Office 2021 and Microsoft 365) 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.

Start your free trial