Excel 2010

Creating Simple Formulas

4 of 6

To Create a Formula using the Point and Click Method:

  1. Select the cell where the answer will appear (B4, for example).
    Selecting cell B4 Selecting cell B4
  2. Type the equal sign (=).
  3. Click on the first cell to be included in the formula (A3, for example).
    Clicking cell A3 Clicking cell A3
  4. Type the operator you need for your formula. For example, type the multiplication sign (*).
  5. Click on the next cell in the formula (B3, for example).
    Clicking cell B3 Clicking cell B3
  6. Press Enter. The formula will be calculated and the value will be displayed in the cell.
    Result in B4 Result in B4