• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Financial Functions > Financial Functions Overview

Financial Functions Overview

Financial functions can be used to calculate house mortgage payments, annuities, accrued interest, and just about any other financial calculation for future, present, or past values. Excel has more than 50 financial functions that can operate independently or can be combined with other functions for a more customized situation. The financial functions are also accompanied by descriptions of the syntax. This helps in understanding the function as a whole. You should take note that when creating functions to return date results, you might have to format the result in a date format. If the return is in digit format, change the cell format from the Format menu. Before moving on to the examples, many of these financial functions require dates for some of their arguments. Errors can occur when text dates are used. To avoid these errors, date arguments should be in the form of dates, not in the form of text. If you suspect the date is text, convert it using DATEVALUE or use the DATE function to explicitly define the date. Also, note that many of these functions require the Analysis ToolPak. To turn on the Analysis ToolPak, choose Tools, Add-Ins.

The functions in Table 10.1 presented in bold are included with examples in this chapter.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint