Excel 2010 Bible

Chapter 10: Introducing Formulas and Functions 219 In some cases, Excel won’t even let you enter an erroneous formula. For examp ...

Part II: Working with Formulas and Functions 220 FIGURE 10.14 If you see this warning, you know that the formula you entered wil ...

Chapter 10: Introducing Formulas and Functions 221 l (^) If Excel is in the middle of a lengthy calculation, it temporarily susp ...

Part II: Working with Formulas and Functions 222 Tip If your worksheet uses any data tables (described in Chapter 36), you may w ...

Chapter 10: Introducing Formulas and Functions 223 Select a scope in which the name will be valid (either the entire workbook o ...

Part II: Working with Formulas and Functions 224 When you use the name MonthlyRate in a formula, it uses the value in B1 divided ...

Chapter 10: Introducing Formulas and Functions 225 The intersection operator is one of three reference operators used with range ...

Part II: Working with Formulas and Functions 226 To refer to a single cell, use the intersection operator. Move to any blank cel ...

Chapter 10: Introducing Formulas and Functions 227 Tips for Working with Formulas .............................................. ...

Part II: Working with Formulas and Functions 228 Press Esc to leave Edit mode. Select cell A2. Choose Home ➪ Clipboard ➪ Paste ...

229 CHAPTER Creating Formulas That Manipulate Text IN THIS CHAPTER How Excel handles text entered into cells Excel worksheet fun ...

Part II: Working with Formulas and Functions 230 If you need to display lots of text in a worksheet, consider using a text box. ...

Chapter 11: Creating Formulas That Manipulate Text 231 Most text functions are not limited to text: They can also operate with c ...

232 Part II: Working with Formulas and Functions Two functions come into play when dealing with character codes: CODE and CHAR. ...

Chapter 11: Creating Formulas That Manipulate Text 233 Determining whether two strings are identical ........................... ...

Part II: Working with Formulas and Functions 234 You’ll find that the previous formula returns TRUE even though the contents of ...

Chapter 11: Creating Formulas That Manipulate Text 235 Here’s a final example of using the & operator. In this case, the for ...

Part II: Working with Formulas and Functions 236 The second argument for the TEXT function consists of a standard Excel number f ...

Chapter 11: Creating Formulas That Manipulate Text 237 You can also use this function to create crude vertical dividers between ...

Part II: Working with Formulas and Functions 238 On the CD The workbook shown in Figure 11.3 also appears on the companion CD-RO ...