Create a simple formula

Why?

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

How?

  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

Hints

  • 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

Calculation operators and order of operations

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×