Creating Complex Formulas

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

Copy and paste formulas

The process to copy and paste a formula is identical to that process used to copy and paste text.

To copy and paste a formula:

  • Select the cell that contains the formula to be copied.
  • Click the Copy button Copy button. Marching "ants" appear around the copied cell(s).

    Copy a Formula
  • Select the cell where the copied formula is to be pasted.
  • Press the Enter key. The formula is copied to the new location.