Home > Sample chapters > Microsoft Office > Excel

Using Formulas and Functions

Creating Simple Cell Formulas

Building calculations in Excel is pretty straightforward. If you want to find the sum of the values in two cells, you just type an equal sign (=), the reference of the first cell, a plus sign (+), and the reference of the second cell. The formula you enter appears on the formula bar, where you can examine and edit it.

Build a Formula

  1. Click the cell in which you want to enter a formula.

  2. Type =.

  3. Type the expression representing the calculation you want to perform.

  4. Press Enter.

    httpatomoreillycomsourcemspimages632171.png

Edit a Formula

  1. Click the cell you want to edit.

  2. Select the part of the formula you want to edit in the formula bar.

  3. Make any changes that you want.

  4. Press Enter.