Excel 2019 Bible

Part II: Working with Formulas and Functions If you’d like to calculate the total projected and total actual sales, you don’t ev ...

Chapter 9: Introducing Formulas and Functions 9 Using formulas within a table In many cases, you’ll want to use formulas within ...

Part II: Working with Formulas and Functions The at symbol (@) that precedes the column header represents “this row.” So [@Actua ...

Chapter 9: Introducing Formulas and Functions 9 Excel will adjust formulas that refer to that table automatically. For example, ...

Part II: Working with Formulas and Functions In some cases, Excel won’t even let you enter an erroneous formula. For example, th ...

Chapter 9: Introducing Formulas and Functions 9 A3 refers to cell A3. Every time the formula in A3 is calculated, it must be cal ...

Part II: Working with Formulas and Functions calculation mode to Manual, which you can do by choosing Formulas ➪ Calculation ➪ C ...

Chapter 9: Introducing Formulas and Functions 9 Using names for constants Many Excel users don’t realize that you can give a nam ...

Part II: Working with Formulas and Functions FIGURE 9.13 Excel allows you to name a formula that doesn’t exist in a worksheet ce ...

Chapter 9: Introducing Formulas and Functions 9 The intersection operator is one of three reference operators used with ranges. ...

Part II: Working with Formulas and Functions Excel created the following eight names: North =Sheet1!$B$2:$E$2 Quarter1 =Sheet1!$ ...

Chapter 9: Introducing Formulas and Functions 9 A better approach is to insert the sales tax rate in a cell—and use the cell ref ...

Part II: Working with Formulas and Functions You can also convert a formula to text by adding an apostrophe (‘) in front of the ...

239 C H A P T E R 10 Using Formulas for Common Mathematical Operations IN THIS CHAPTER Calculating percentages Rounding numbers ...

Part II: Working with Formulas and Functions FIGURE 10.1 Calculating the percent of goal There isn’t much to this formula. You’r ...

Chapter 10: Using Formulas for Common Mathematical Operations  . . . . . . . . . . . . . . .  10 Calculating percent variance A ...

Part II: Working with Formulas and Functions Calculating percent variance with negative values In the previous section, “Calcula ...

Chapter 13: Using Formulas for Conditional Analysis. . . . . . . . . . . . . . . . . . . . . . . . . . .  10 Calculating a perce ...

Part II: Working with Formulas and Functions Again, note the use of absolute references in the SUM function. This ensures that t ...

Chapter 10: Using Formulas for Common Mathematical Operations 10 FIGURE 10.8 Applying a percent increase and decrease using a si ...