Creating Complex Formulas

In Excel complex formulas can include several operations. Use complex formulas in Excel to calculate more extensive data.

Revising formulas

You can revise any formula that was previously written in a worksheet.

To revise a formula using the keyboard:

  • Double-click the cell that contains the formula you want to revise.
  • The cursor can now move left and right between the values in the formula in cell B5.

    Revise Formula Using the Keyboard
  • Make the necessary changes to the formula.
  • Press the Enter key, or click the Enter button to accept the new formula.