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).

    Klik på resultatcelle

  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.

    Klik på formellinjen og derefter på lighedstegnet

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

    Klik på den første celle i formlen, og klik derefter på plustegnet

  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.

    Klik på andre celler i formlen

    The formula result appears.

    Resultat i B5, formel i formellinjen

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

Change a formula

Calculation operators and order of operations

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!

×