Chapter 24. Using Powerful Functions: Logical, Lookup, and Database Functions
In this chapter
Examples of Logical Functions 531
Examples of Information Functions 539
Examples of Lookup and Reference Functions 550
Examples of Database Functions 579
This chapter covers four groups of workhorse functions. If you are processing spreadsheets of medium complexity, you will find yourself turning to logical and lookup functions regularly.
- The logical functions, including the ubiquitous
IF function, help you make decisions.
- The information functions might be less important than they once were, now that Microsoft has added the
IFERROR function, but
TYPE still come in handy.
- The lookup functions include the powerful
MATCH, and ...