Excel 2010 Bible

Chapter 15: Creating Formulas for Financial Applications 339 FIGURE 15.6 Using a one-way data table to display three loan calcul ...

Part II: Working with Formulas and Functions 340 Click OK. Excel inserts an array formula that uses the TABLE function with a s ...

Chapter 15: Creating Formulas for Financial Applications 341 Enter various values for the second input cell in successive rows, ...

Part II: Working with Formulas and Functions 342 FIGURE 15.9 This worksheet tracks loan payments that are made on an irregular b ...

Chapter 15: Creating Formulas for Financial Applications 343 Cell Formula Description F6 =IF(C6<>””,F5+B6,””) The formula ...

Part II: Working with Formulas and Functions 344 Figure 15.10 shows a worksheet set up to make simple interest calculations. The ...

Chapter 15: Creating Formulas for Financial Applications 345 FIGURE 15.11 Using a series of formulas to calculate compound inter ...

Part II: Working with Formulas and Functions 346 Cell B9 contains the following formula that calculates the periodic interest ra ...

Chapter 15: Creating Formulas for Financial Applications 347 FIGURE 15.13 Calculating interest by using daily compounding. Note ...

Part II: Working with Formulas and Functions 348 Future value of a series of deposits .......................................... ...

Chapter 15: Creating Formulas for Financial Applications 349 This formula returns $2,432.75, which represents the total of your ...

Part II: Working with Formulas and Functions 350 TABLE 15.4 (continued) Cell Formula Description B13 None (input cell) The annua ...

Chapter 15: Creating Formulas for Financial Applications 351 Function Depreciation Method Arguments* SYD Sum of the year’s digit ...

Part II: Working with Formulas and Functions 352 FIGURE 15.15 A comparison of four depreciation functions. FIGURE 15.16 This cha ...

Chapter 15: Creating Formulas for Financial Applications 353 The VBD function is useful if you need to calculate depreciation fo ...

...

355 CHAPTER Introducing Array Formulas IN THIS CHAPTER The definition of an array and an array formula One-dimensional versus tw ...

Part II: Working with Formulas and Functions 356 This section presents two array formula examples: an array formula that occupie ...

Chapter 16: Introducing Array Formulas 357 The formula is entered into all six selected cells. If you examine the Formula bar, y ...

Part II: Working with Formulas and Functions 358 FIGURE 16.2 The array formula in cell C9 calculates the total sales without usi ...