Creating Complex Formulas

In Excel XP 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 containing 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.