Creating Formulas in Worksheets

You can create formulas in worksheet cells. Formulas are stored until deleted from the cell.

  To create formulas within cells:

  1. In the worksheet, click a cell.

  2. Enter a formula.

    Begin with an equal sign and proceed with the formula. For example:

    =SUM(B5:B18)

    To reference a cell in your calculation, click that cell following a mathematical operator.