Formulas and Functions

340
The in-depth examples and additional topics in this chapter
illustrate working with some of the more complex functions.
Additional Examples and Topics Included
The following table tells you where to nd in-depth examples and additional topics
that illustrate working with some of the more complex functions with real-world
examples.
If you wish to see an example or learn more
about
See this section
The denitions and specication of arguments
used in nancial functions
“Common Arguments Used in Financial
Functions” on page 341
The time value of money (TVM) functions “Choosing Which Time Value of Money Function
to Use” on page 348
TVM functions dealing with xed periodic cash
ows and xed interest rates
“Regular Cash Flows and Time Intervals” on
page 348
TVM functions that can deal with uneven
(variable periodic) cash ows
“Irregular Cash Flows and Time Intervals” on
page 350
The function that may be most helpful in
answering a common nancial question
“Which Function Should You Use to Solve
Common Financial Questions?” on page 3 51
Using nancial functions to create a loan
amortization table
“Example of a Loan Amortization Table” on
page 353
The various functions that round numbers “More on Rounding” on page 355
Using logical and information functions together
to build a more powerful formula
“Using Logical and Information Functions
Together” on page 358
Understanding conditions and how to use
wildcards with conditions
“Specifying Conditions and Using Wildcards” on
page 360
Using statistical functions to analyze the results
of a survey
“Survey Results Example” on page 362
13
Additional Examples and Topics