This is exactly what I am looking for. My students will love this site.”

Online Learner

Creating Opportunities For A Better Life.®

Excel 2010

Single page view print copy

Creating Simple Formulas

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 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
1 2 3 4 5 6