Microsoft Office Tutorials and References

In Depth Information

**Chapter 14: Everyday functions**

CHAPTER 14

Everyday functions

Understanding mathematical functions .............537

Understanding text functions. . . . . . . . . . . . . . . . . . . . . . 545

Understanding logical functions ...................551

Understanding information functions ..............554

Understanding lookup and reference functions ......556

THIS
CHAPTER
describes some of the more useful functions Microsoft Excel has to offer. To

keep this topic from threatening the structural integrity of your bookshelf, we had to

make some hard choices about which functions to highlight. Therefore, this chapter

(along with Chapters 15, 16, and 17) by no means represents a comprehensive reference.

For complete information about all the built-in functions, you can use a number of

onscreen tools, which are covered in “Using the built-in function reference in Excel” in Chapter

13, “Using functions.” Appendix C, “Function reference,” lists every function available in

Excel, along with the basic information you need to put each one to use, and it includes

cross-references to any information available in this and other chapters.

For more information, see Chapter 15, “Formatting and calculating date and time,” Chapter

16, “Functions for financial analysis,” and Chapter 17, “Functions for analyzing statistics.”

Understanding mathematical functions

Most of the work you do in Excel probably involves at least a few mathematical functions.

The most popular among these is the SUM function, but Excel is capable of calculating just

about anything. In the next sections, we discuss some of the most used (and most useful)

mathematical functions in Excel.

Using the SUM function

The SUM function totals a series of numbers. It takes the form =SUM(
number1
,
number2
, …).

The
number
arguments are a series of as many as 30 entries that can be numbers, formulas,

ranges, or cell references that result in numbers. SUM ignores arguments that refer to text

values, logical values, or blank cells.

The Sum button

Because SUM is such a commonly used function, Excel provides the Sum button on the

Home tab on the ribbon, as well as the AutoSum button on the Formulas tab. In addition to

537