Excel Financial Functions

Excel functions, formulas and examples

 

Excel tips on functions and formulas

Excel Functions and Formulas

excel-functions tutorial

Excel macros (VBA)

Excel and VBA Expert

Excel fonctions et formules

Special

Excel Functions

2003

 

sumproduct

index-match

subtotal

iserror

countif

sumif

hlookup

lookup

vlookup

 

 

Special

Excel Functions

2007

 

averageif

averageifs

countifs

sumifs

iferror

 

 

 

 

 

 

 

Lesson 4: Excel Spreadsheets Financial Functions (53)

In annex 4 you have found a description of all 53 Excel functions in the "Financial" category. Below is the list of the 4 most useful ones.

Functions What it Does
FV Returns the future value of an investment
NPER Returns the number of periods for an investment
PMT Returns the periodic payment for an annuity
RATE Returns the interest rate per period of an annuity

The financial functions are among the less user friendly, the less intuitive in Excel. In the downloadable tutorial on Excel functions and formulas you will find example of formulas using each of these functions and even many of them assembled in easy and powerful formulas.

If you are using a version of Excel earlier than 2007 you need to activate the "Excel Analysis Toolpack" to make some of the functions above available.

Excel Functions and Formulas Sitemap

Go to the next lesson:
Lesson 5: Excel Information Functions

See the complete version of this lesson in
The Tutorial on Excel
Functions

 

 

 

Excel tips on functions and formulas

excel-functions tutorial

Excel macros (VBA)

Excel and VBA Expert

Excel fonctions et formules

SUMPRODUCT  ¦  INDEX/MATCH  ¦  SUBTOTAL  ¦  ISERROR  ¦  COUNTIF  ¦  SUMIF  ¦  HLOOKUP  ¦  LOOKUP  ¦  VLOOKUP
AVERAGEIF  ¦  AVERAGEIFS  ¦  COUNTIFS  ¦  SUMIFS  ¦  IFERROR