Microsoft Office Tutorials and References
In Depth Information
Function Reference Chapters
arguments. The examples are designed to give you ideas of how to use the func-
tions in real life.
Function coverage is broken out as follows:
• Chapter 11 describes functions that many people encounter in their
everyday life: some of the math functions, date functions, and text
• Chapter 12 describes functions that are a bit more difficult but that
should be a part of your everyday arsenal. These include a series of
functions for making decisions in a formula. They include the IF func-
tion and are known collectively as the logical functions. Chapter 12
also describes the information, lookup, and database functions.
functions. The first section of the chapter includes functions that
anyone can use to calculate a car loan or plan for retirement. The
later sections of the chapter include functions for depreciation,
business valuation, and bond investing.
functions. Many of these functions are functions that are useful
everyday — for example, AVERAGE(), MAX(), MIN(), and RANK(). The
chapter also describes many highly specialized functions that are
useful to scientists and engineers.
• Chapter 15 describes trigonometry and engineering functions. The tri-
gonometry functions are grouped along with the other math functions
in the Math Functions icon, but they are described separately in this
book because they are more specialized. The engineering functions are