O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Putting Worksheet Functions to Use

Excel has over 300 functions, including those available in various add-ins. The following sections list some of the tasks you can accomplish by using functions in each category.

Calculating Financial Formulas

Excel includes a large number of financial functions—52 in all—covering everything from simple household budget problems, such as calculating a house payment, to complex tasks such as figuring the bond-equivalent yield for a U.S. Treasury bill (TBILLEQ) or the accrued interest for a security that pays interest at maturity (ACCRINTM).

Most of the more advanced financial functions, including those that calculate depreciation schedules (DB, DDB, SLN, SYD, and VDB) and internal rates of return (IRR, MIRR) are ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required