Formulas and Functions
Table Of Contents
- Formulas and Functions
- Contents
- Preface: Welcome to iWork Formulas & Functions
- Chapter 1: Using Formulas in Tables
- The Elements of Formulas
- Performing Instant Calculations in Numbers
- Using Predefined Quick Formulas
- Creating Your Own Formulas
- Removing Formulas
- Referring to Cells in Formulas
- Using Operators in Formulas
- The String Operator and the Wildcards
- Copying or Moving Formulas and Their Computed Values
- Viewing All Formulas in a Spreadsheet
- Finding and Replacing Formula Elements
- Chapter 2: Overview of the iWork Functions
- Chapter 3: Date and Time Functions
- Chapter 4: Duration Functions
- Chapter 5: Engineering Functions
- Chapter 6: Financial Functions
- Chapter 7: Logical and Information Functions
- Chapter 8: Numeric Functions
- Chapter 9: Reference Functions
- Chapter 10: Statistical Functions
- Listing of Statistical Functions
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FORECAST
- FREQUENCY
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- HARMEAN
- INTERCEPT
- LARGE
- LINEST
- Additional Statistics
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MEDIAN
- MIN
- MINA
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- TDIST
- TINV
- TTEST
- VAR
- VARA
- VARP
- VARPA
- ZTEST
- Chapter 11: Text Functions
- Chapter 12: Trigonometric Functions
- Chapter 13: Additional Examples and Topics
- Index
Chapter 6 Financial Functions 97
Function Description
“COUPDAYSNC” (page 108) The COUPDAYSNC function returns the number
of days between the settlement date and the end
of the coupon period in which settlement occurs.
“COUPNUM” (page 109) The COUPNUM function returns the number
of coupons remaining to be paid between the
settlement date and the maturity date.
“CUMIPMT” (page 110 ) The CUMIPMT function returns the total interest
included in loan or annuity payments over a
chosen time interval based on xed periodic
payments and a xed interest rate.
“CUMPRINC” (page 11 2 ) The CUMPRINC function returns the total
principal included in loan or annuity payments
over a chosen time interval based on xed
periodic payments and a xed interest rate.
“DB” (page 114 ) The DB function returns the amount of
depreciation of an asset for a specied period
using the xed-declining balance method.
“DDB” (page 116 ) The DDB function returns the amount of
depreciation of an asset based on a specied
depreciation rate.
“DISC” (page 117 ) The DISC function returns the annual discount
rate of a security that pays no interest and is sold
at a discount to its redemption value.
“EFFECT” (page 11 9 ) The EFFECT function returns the eective annual
interest rate from the nominal annual interest
rate based on the number of compounding
periods per year.
“FV” (page 12 0 ) The FV function returns the future value of an
investment based on a series of regular periodic
cash ows (payments of a constant amount and
all cash ows at constant intervals) and a xed
interest rate.
“INTRATE” (page 12 2 ) The INTRATE function returns the eective annual
interest rate for a security that pays interest only
at maturity.
“IPMT” (page 12 3 ) The IPMT function returns the interest portion
of a specied loan or annuity payment based on
xed, periodic payments and a xed interest rate.
“IRR” (page 12 5 ) The IRR function returns the internal rate of
return for an investment that is based on a series
of potentially irregular cash ows that occur at
regular time intervals.