Chapter 23. Using Everyday Functions: Math, Date and Time, and Text Functions

In this chapter

Examples of Math Functions 458

Dates and Times in Excel 484

Examples of Date and Time Functions 490

Examples of Text Functions 505

Excel offers many functions for dealing with basic math, dates and times, and text. This chapter describes the functions found under the Date & Time icon and the Math & Trig icon on the Formulas ribbon.

Table 23.1 provides an alphabetical list of all of Excel 2007’s math functions. Detailed examples of these functions are provided later in this chapter.

Table 23.1. Alphabetical List of Math Functions

Image

Table 23.2 provides ...

Get Special Edition Using Microsoft® Office Excel® 2007 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.