Chapter 6
Working with logical and information functions
In this chapter, you will:
Add logical tests to your formulas with the
IF()
functionPerform multiple logical tests with nested
IF()
functions and theAND()
andOR()
functionsCreate 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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.