Create a simple formula


When you create a formula, Excel does your math for you.


  1. Click the cell where you want the result to appear (for example, B5).

    Click result cell

  2. Click in the formula bar, and then type an equal sign (=).

    The formula appears in the cell and in the Formula Bar. If you don't see the Formula Bar, on the View menu, click Formula Bar.

    Click formula bar, then click equal sign

  3. Click the first cell that you want to include in the total (for example, B2), and then type a plus sign (+).

    Click first cell in formula, then click plus sign

  4. Click additional cells to capture all the data that you want to include in the total (for example, =B2+B3+B4), and then press RETURN.

    Click other cells in formula

    The formula result appears.

    Result in B5, formula in formula bar


  • Do not format numbers as you enter them in formulas. For example, even if the value that you want to enter is $1,000, enter 1000 in the formula.

  • Make sure that you match all open and close parentheses.

See also

Enter a formula

Change a formula

Calculation operators and order of operations

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!