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 edit a formula:

  1. Click the cell you want to edit.
  2. Insert the cursor in the formula bar, and edit the formula as desired. You can also double-click the cell to view and edit the formula directly from the cell.
  3. When you're done, press Enter or select the Enter command Cursor.
    Edit a formulaEdit a formula
  4. The new value will be displayed in the cell.
    ResultResult

If you change your mind, use the Cancel command Cursor in the formula bar to avoid accidentally making changes to your formula.