Excel for Marketing Managers

Calculation Basics

Calculation

Basics

(^)

5. Enter a minus sign and select the third element.
   Next, type the minus sign on the keyboard. Excel will return the focus to
   the original location of B7. Press the Up arrow one time to subtract B6 from
   the formula.


6. Press Enter to tell Excel that the formula is complete.
   When you type Enter, Excel calculates an answer of 3. Move the cellpointer
   back to B7 to examine the formula in the Formula bar.

Now that you have learned the three methods for entering formulas, you can

use whichever method suits you the best. In the remaining sections of this

chapter, you will see the formulas to use for various mathematical operations.

You can use whichever method you prefer for entering these formulas.

Figure 17

Excel proposes the next element in the formula

Figure 18

Selecting the next element

Figure 19

Completed formula