Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Excel basics › Add, subtract, multiply, divide

How to Add, Subtract, Multiply and Divide in Excel

Every calculation in Excel starts with an equals sign. After that you use the same signs as on a calculator, with one difference: multiply is * and divide is /. These are the formulas, with examples you can copy.

In this guide
  1. The signs
  2. Add
  3. Try it yourself
  4. Subtract
  5. Multiply
  6. Divide
  7. Whole column
  8. Order of operations
  9. Keep learning
  10. FAQ

The calculation signs

SignDoesExample
+Add=A2+B2
-Subtract=A2-B2
*Multiply=A2*B2
/Divide=A2/B2
^Power=A2^2

Type the formula in the cell where you want the answer and press Enter. Click a cell instead of typing its address: Excel fills it in for you, and the answer updates when the numbers change.

Add

For two or three cells, use the plus sign. For a whole row or column, SUM is shorter and doesn't skip a cell by mistake:

=A2+B2+C2 =SUM(A2:A10)

Quickest of all: click the cell under a column of numbers and click AutoSum (Σ) on the Home tab, or press Alt+=. Read more in the SUM guide.

Try it yourself: multiplying

Reading is one thing, typing it is another. Build the formula below step by step: the tips tell you what to type next, and you can click or drag across cells to add them, just like in Excel.

Task: Work out the total in D2: quantity times price: =B2*C2

Subtract

Excel has no SUBTRACT function: you use the minus sign. To take several numbers off one amount, subtract their sum:

=A2-B2 =B1-SUM(B2:B10)

The first formula gives the difference between two cells; the second takes a whole list of expenses off the budget in B1.

Multiply

Multiply with the asterisk *, not with an x. A typical example: quantity times price.

ABCD
1ProductQuantityPriceTotal
2Notebook4$3.50$14.00
3Pen10$1.20$12.00
4Folder3$2.75$8.25
=B2*C2

For many cells in a row there is PRODUCT, and to multiply two columns and add up the results in one go, use SUMPRODUCT.

Divide

=A2/B2

Divide with the slash /. Divide by an empty cell or by 0 and Excel shows #DIV/0!; hide it with IFERROR:

=IFERROR(A2/B2, "")

For only the whole part of a division use QUOTIENT; for what's left over use MOD. =QUOTIENT(17, 5) gives 3 and =MOD(17, 5) gives 2.

A whole column at once

Write the formula once, in the first row, and copy it down: double-click the small square at the bottom right of the cell (the fill handle) and Excel fills it down to the last row of your data. The references move along: D2 becomes D3, D4 and so on.

To multiply every row by the same number, such as a VAT rate in F1, lock that cell with dollar signs so it doesn't move when you copy: =C2*$F$1. More in absolute references.

The order Excel calculates in

Excel follows the maths rules: first brackets, then powers, then multiply and divide, then add and subtract. So =10+2*3 gives 16, while =(10+2)*3 gives 36. When in doubt, add brackets.

Frequently asked questions

Is there a subtract function in Excel?

No. Use the minus sign: =A2-B2. To subtract several cells at once: =A2-SUM(B2:B5).

Why does Excel show my formula instead of the answer?

The formula must start with = and the cell must not be formatted as Text. Change the format to General, click in the cell and press Enter again. Also check that Show Formulas (Ctrl+`) is switched off.

How do I multiply a whole column by the same number?

Put the number in a cell, for example F1, use =A2*$F$1 in the first row and copy it down. Or copy the number and use Paste Special › Multiply to change the values themselves.

How do I divide and round at the same time?

Put the division inside ROUND: =ROUND(A2/B2, 2) gives two decimals.