O'Reilly logo

Special Edition Using Microsoft® Office Excel® 2007 by Bill MrExcel Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 INFO, CELL, and TYPE still come in handy.
  • The lookup functions include the powerful VLOOKUP, MATCH, and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required