Excel 2010 Bible

Chapter 14: Creating Formulas That Look Up Values 319 is exactly what you want to happen because returning an approximate match ...

Part II: Working with Formulas and Functions 320 Using the LOOKUP function requires that the lookup range (in this case, the Pla ...

Chapter 14: Creating Formulas That Look Up Values 321 The array formula that follows is in cell B2. This formula does a case-sen ...

Part II: Working with Formulas and Functions 322 Determining letter grades for test scores ..................................... ...

Chapter 14: Creating Formulas That Look Up Values 323 grade values weighted by the credit hours of the course. A one-hour course ...

Part II: Working with Formulas and Functions 324 FIGURE 14.12 This table demonstrates a two-way lookup. To simplify things, the ...

Chapter 14: Creating Formulas That Look Up Values 325 Tip Another way to accomplish a two-way lookup is to provide a name for ea ...

Part II: Working with Formulas and Functions 326 The following array formula displays the corresponding code for an automobile m ...

Chapter 14: Creating Formulas That Look Up Values 327 Looking up a value by using the closest match ............................ ...

Part II: Working with Formulas and Functions 328 If two values in the Data range are equidistant from the Target value, the form ...

329 CHAPTER Creating Formulas for Financial Applications IN THIS CHAPTER A brief overview of the Excel functions that deal with ...

Part II: Working with Formulas and Functions 330 The time value of money depends on your perspective. In other words, you’re eit ...

Chapter 15: Creating Formulas for Financial Applications 331 Note The loan calculations in this section all assume a fixed-rate ...

Part II: Working with Formulas and Functions 332 The following formula returns the amount paid to principal for the first month ...

Chapter 15: Creating Formulas for Financial Applications 333 NPER .............................................................. ...

Part II: Working with Formulas and Functions 334 FIGURE 15.1 Using the PMT function to calculate a periodic loan payment amount. ...

Chapter 15: Creating Formulas for Financial Applications 335 FIGURE 15.2 This chart shows the relative interest and principal am ...

Part II: Working with Formulas and Functions 336 FIGURE 15.3 This worksheet calculates the number of payments required to pay of ...

Chapter 15: Creating Formulas for Financial Applications 337 Creating a loan amortization schedule ............................. ...

Part II: Working with Formulas and Functions 338 TABLE 15.2 Formulas Used to Calculate an Amortization Schedule Cell Formula Des ...