Microsoft Office Tutorials and References
In Depth Information
12. Using Powerful Functions: Logical, Lookup, Web, and Database Functions
and Database Functions
This chapter covers five groups of workhorse functions. If you process
spreadsheets of medium complexity, you will turn to logical and lookup func-
• The logical functions, including the ubiquitous IF function, help make
decisions. Excel 2013 adds the XOR function (for eXclusive OR) and the
• 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. New in Excel 2013 are the SHEET,
SHEETS, and ISFORMULA functions.
• The lookup functions include the powerful VLOOKUP, MATCH, and
INDIRECT functions. These functions are invaluable, particularly
when you are doing something in Excel when it would be better to use Ac-
cess. In addition, let ’ s face it: With 1.1 million rows in Excel 2013, we
will all do more things in Excel that should be done in Access. Excel
2013 adds the FORMULATEXT function.
• Excel 2013 adds the Web category, with RNCODEURL, FILTERXML, and
• Finally, the database functions provide the DSUM functions. Even
though these functions fell out of favor with the introduction of pivot
tables, they are a powerful set of functions that are worthwhile to
Table 12.1 provides an alphabetical list of all Excel 2013 ’ s logical func-
tions. Detailed examples of these functions are provided later in this chapter.