Formulas and Functions

Listing of Function Categories
There are several categories of functions. For example, some functions perform
calculations on date/time values, logical functions give a Boolean (TRUE or FALSE)
result, and other functions perform nancial calculations. Each of the categories of
functions is discussed in a separate chapter.
“Listing of Date and Time Functions” on page 42
“Listing of Duration Functions” on page 64
“Listing of Engineering Functions” on page 72
“Listing of Financial Functions” on page 96
“Listing of Logical and Information Functions” on page 155
“Listing of Numeric Functions” on page 167
“Listing of Reference Functions” on page 206
“Listing of Statistical Functions” on page 225
“Listing of Text Functions” on page 306
“Listing of Trigonometric Functions” on page 326
40 Chapter 2 Overview of the iWork Functions