Entering a formula in the worksheet

You enter a formula in a cell much as you enter any data. Building your worksheet provides basic information about entering and editing data. More power with formulas describes all the basic parts of a formula and the different types of formulas.

  1. Click the cell where you want to enter the formula.

  2. Type + to start the formula.

  3. Enter operands, operators, and parentheses as needed.

    When referring to data in a formula, type the name or address of the cell or range that contains the data; for example, +A6-B3.

  4. When the formula is complete, press ENTER.

  5. (Optional) If your spreadsheet displays *** (asterisks), widen the column.

After you enter a formula in a cell, your spreadsheet displays the formula's result in the cell. To see the actual formula, look in the contents box at the top of the worksheet. If the formula results in ERR, or your spreadsheet does not accept the formula, check for common errors.



Guidelines for entering formulas

Use these guidelines when entering a formula:



See also
More power with @functions
When and how formulas recalculate
Controlling how a formula refers to data
Editing a formula
Entering a range address in a formula
Entering a range name in a formula
Copying a formula
Moving a formula