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
The calculation signs
| Sign | Does | Example |
|---|---|---|
+ | 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.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Product | Quantity | Price | Total |
| 2 | Notebook | 4 | $3.50 | $14.00 |
| 3 | Pen | 10 | $1.20 | $12.00 |
| 4 | Folder | 3 | $2.75 | $8.25 |
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/B2Divide 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.
Keep learning
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.