Creating Simple Formulas

When using formulas in Excel you can add, subtract, multiply, and divide. Use simple Excel formulas to also make cell references in Excel.

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 equals sign (=).
  3. Click 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 the formula. For example, type the multiplication sign (*).
  5. Click 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