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 ...
Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
