Business Solutions Formulas and Functions with Microsoft® Office Excel 2007

Chapter 8. Working with Logical and Information Functions

IN THIS CHAPTER

• Adding Intelligence with Logical Functions 167

• Building an Accounts Receivable Aging Worksheet 182

• Getting Data with Information Functions 184

I mentioned in Chapter 6, “Understanding Functions,” that one of the advantages to 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 those functions that can add to your worksheet models the two cornerstones of good business analysis—intelligence and knowledge. You get these via Excel’s logical and information functions, which I describe in detail in this ...