Excel for Marketing Managers

Calculation Basics

Calculation
Basics

2. Type in the rest of the formula.
   In this example, you will use the Touch-typing method of entering the
   formula. Without typing any spaces, finish typing the formula as follows:
   B4+B


3. Press Enter to tell Excel that the formula is complete.
   When your screen looks like Figure 3, press the Enter key on the keyboard.
   After you type Enter, Excel will calculate that the sum is 30. Excel will also
   move the cellpointer down one cell to B7.


4. Look at the formula.
   Press the Up arrow one time to move the cellpointer back to cell B6. When
   B6 is selected, look at the formula bar just above the spreadsheet. Although

Figure 3

Using a formula to add values in two cells

Figure 4

Pointer automatically moves down one

cell when calculation is done.

Figure 2

Always start a formula with an

equals sign.