Excel for Marketing Managers

Calculation Basics

Calculation

Basics

the spreadsheet shows a value of 30 in the cell, the formula bar reveals that

this cell actually contains a formula of =B4+B5.

5. See how the formula result changes when the elements change.
   Here is the “miracle” of spreadsheets. Move the cellpointer up to cell B
   and type a different number instead of the 20. Type 200 and press Enter.
   The cellpointer will move down to cell B5, but all formulas that reference
   B4 in the entire worksheet will instantly recalculate. Thus, cell B6 becomes
   210.

Using the Mouse Method (Subtraction)

Figure 7 shows a subtraction story problem. In this case, you will want to set
up a formula that subtracts B5 from B4. In this example, you will use the
Mouse method for entering parts of the formula.

1. Start your formula with an equals sign.
   As before, you have to type the equals sign on the keyboard to start the
   formula.

Figure 5

Formula bar displays the formula

used to derive the value in a cell.

Figure 6

A formula’s value automatically updates when any

cells referenced in that formula change.