Excel 2010 Bible

Chapter 10: Introducing Formulas and Functions 199 This formula has four sets of parentheses — three sets are nested inside the ...

Part II: Working with Formulas and Functions 200 Examples of formulas that use functions ....................................... ...

Chapter 10: Introducing Formulas and Functions 201 Function arguments .......................................................... ...

Part II: Working with Formulas and Functions 202 values, literal text strings, expressions, and even other functions. Here are s ...

Chapter 10: Introducing Formulas and Functions 203 FIGURE 10.2 Excel displays a drop-down list when you enter a formula. Enterin ...

Part II: Working with Formulas and Functions 204 The Formula Autocomplete feature (introduced in Excel 2007) makes entering form ...

Chapter 10: Introducing Formulas and Functions 205 Pasting range names into formulas ........................................... ...

Part II: Working with Formulas and Functions 206 Cross-Reference See Chapter 4 for information about defining names. n FIGURE 10 ...

Chapter 10: Introducing Formulas and Functions 207 l (^) Choose Formulas ➪ Function Library ➪ Insert Function. l Use the Insert ...

Part II: Working with Formulas and Functions 208 FIGURE 10.6 The Function Arguments dialog box. Tip Yet another way to insert a ...

Chapter 10: Introducing Formulas and Functions 209 l (^) As you become familiar with the functions, you can bypass the Insert Fu ...

Part II: Working with Formulas and Functions 210 reflect the new value. If you didn’t use references in your formulas, you would ...

Chapter 10: Introducing Formulas and Functions 211 In this case, copying the formula to the cells below would produce incorrect ...

Part II: Working with Formulas and Functions 212 Notice that both cell references are mixed. The reference to cell B3 uses an ab ...

Chapter 10: Introducing Formulas and Functions 213 Referencing cells in other worksheets ....................................... ...

Part II: Working with Formulas and Functions 214 Cross-Reference See Chapter 27 for more information about linking workbooks. n ...

Chapter 10: Introducing Formulas and Functions 215 On the CD This workbook is available on the companion CD-ROM. It is named tab ...

Part II: Working with Formulas and Functions 216 Note You can toggle the Total Row display via Table Tools ➪ Design ➪ Table Styl ...

Chapter 10: Introducing Formulas and Functions 217 Although the formula was entered into the first row of the table, that’s not ...

Part II: Working with Formulas and Functions 218 This formula will always return the sum of all the data (excluding calculated T ...