Excel 2007 Pocket Guide, 2nd Edition

Chapter 3. Formula Reference

This chapter provides quick but detailed references to the most useful functions in Excel 2007. You probably already use some of these functions, but you’ll probably encounter a few that you haven’t used before. You’ll find the following sections in this chapter:

• New formulas in Excel 2007

• Math formulas

• Date and time formulas

• Financial formulas

• Lookup and reference formulas

• Logical formulas

• Text formulas

• Statistical formulas

New Formulas in Excel 2007

In response to user requests, the Excel product team created six new worksheet functions:

AVERAGEIF

Calculates the average of cells that meet a single criteria.

AVERAGEIFS

Calculates the average of cells that meet multiple criteria.

SUMIFS

Finds the sum of cells that meet multiple criteria (the SUMIF function, which calculates the sum of cells that meet a single criteria, was present in earlier versions of Excel).

COUNTIFS

Counts the number of cells that meet multiple criteria (the COUNTIF function, which counts the number of cells that meet a single criteria, was present in earlier versions of Excel).

RANDBETWEEN

Returns a random integer between two values you define.

IFERROR

Displays a custom message if a cell contains an error.

You find detailed descriptions of each of these new functions later in this section.

Note

In Excel 2003 and earlier, you had to install the Analysis ToolPak to use many advanced statistical functions. Those functions, which include chi-squared distribution and ANOVA analysis tools, are built into Excel ...