Excel Add, Subtract, and Multiply: Formulas and Fixes
To add, subtract, or multiply in Excel, start a formula with an equals sign (=), then use +, – or * between numbers or cell references. For example, =A1+B1 adds two cells, =A1-B1 subtracts the second from the first, and =A1*B1 multiplies them; Excel displays the result in the formula cell.
Basic Excel arithmetic formulas
Excel uses familiar arithmetic symbols, but a formula must begin with an equals sign so the program knows to calculate rather than display the entry as text. You can type numbers directly, refer to cells, or combine both approaches.
=8+5returns 13.=A1-B1subtracts the value in B1 from the value in A1.=A1*B1multiplies the values in A1 and B1.
Enter a formula in a blank cell and press Enter. The cell shows the calculated result, while the formula bar displays the formula when that cell is selected. If you change a referenced value, Excel normally recalculates the result automatically.
How to add values in Excel
For a short addition, use plus signs between the numbers or cell references: =A1+B1+C1. This works well when each item has a specific role, such as adding tax to a subtotal or combining two amounts.
For a continuous range, use the SUM function. For example, =SUM(A1:A10) adds the numeric values in cells A1 through A10. The colon means “through,” including both endpoints. You can also add separate cells or ranges with commas, as in =SUM(A1,A3,A5:A8).
To use Excel’s AutoSum feature, select the cell where you want the total, then choose Home > AutoSum (shown with the sigma symbol) or press Alt+= on many Windows keyboards. Check the highlighted range before confirming: Excel guesses which adjacent cells to total, and the guess may not match your intended data.
How to subtract values
There is no separate subtraction function needed for ordinary subtraction. Use the minus sign between values: =A1-B1. The order matters: this formula subtracts B1 from A1, so reversing the references produces a different result.
To subtract several expenses from a starting balance, you can write =A1-B1-C1. You can also subtract a total: =A1-SUM(B1:B5) subtracts the sum of B1 through B5 from A1. If the result is negative, Excel is reporting that the amount subtracted is greater than the starting value; it does not automatically indicate an error.
How to multiply values
Excel uses the asterisk (*) for multiplication, not the letter x. For example, =A1*B1 can calculate a line total when A1 contains a quantity and B1 contains a unit price. If A1 is 4 and B1 is 12.50, the formula returns 50.
To multiply several values, place an asterisk between each one, such as =A1*B1*C1. For a range of values, the PRODUCT function is an alternative: =PRODUCT(A1:A5) multiplies the numeric values in that range. It can be useful for compound factors, but for a simple two-cell calculation, the asterisk is usually easier to read.
Combine operations and use parentheses
A formula can include addition, subtraction, and multiplication together. Excel follows the standard order of operations: calculations in parentheses first, then exponents, then multiplication and division, and finally addition and subtraction. Operations at the same level are evaluated from left to right.
=2+3*4returns 14 because multiplication happens before addition.=(2+3)*4returns 20 because the parentheses make Excel add first.=A1*(B1+C1)multiplies A1 by the sum of B1 and C1.
Use parentheses when they clarify the intended calculation, even if they are not strictly necessary. They make formulas easier to check and help prevent mistakes when a formula is later edited.
Copy formulas and calculate a column
Once a formula works for one row, you can copy it to other rows. For example, enter =A2*B2 in C2, then drag the fill handle—the small square at the lower-right corner of the selected cell—down the column. Excel adjusts the relative references in each row, producing =A3*B3, =A4*B4, and so on.
If a reference should stay fixed while copying, add dollar signs to make it absolute. In =A2*$B$1, the row reference A2 changes as the formula is copied, but $B$1 remains fixed. This is useful when every row uses the same multiplier or rate stored in one cell. Select a reference in the formula and press F4 on many keyboards to cycle through reference styles.
Common formula problems
If Excel displays the formula itself instead of its result, check that the entry begins with = and that the cell is not formatted as Text. Change the cell format to General or Number, then re-enter the formula. A leading apostrophe can also make an entry display as text.
- Wrong symbol: Use
*for multiplication. The letter x is not the multiplication operator in an Excel formula. - Missing equals sign:
A1+B1is not normally evaluated as a formula; enter=A1+B1. - Unexpected result: Confirm the cell references, operation order, and parentheses. A formula may be valid but use the wrong cells.
- Numbers stored as text: Values that look numeric may not behave like numbers if imported or entered as text. Check the cell format and the source data.
- Calculation not updating: Check Formulas > Calculation Options. If calculation is set to Manual, recalculate the workbook or switch to Automatic.
Formatting changes how a result looks, not the underlying calculation. For instance, a cell formatted to show two decimal places may display 12.35 while retaining additional precision internally. Avoid rounding only by changing the display format when later calculations require a rounded value; use the ROUND function if the calculation itself must be rounded.
Frequently Asked Questions
What symbol do I use to multiply in Excel?
Use the asterisk (*), as in =A1*B1. Do not use the letter x.
How do I add a whole column in Excel?
Use a range with SUM, such as =SUM(A:A). If you place the formula in column A, avoid including its own cell in the sum, because that creates a circular reference.
Can I add, subtract, and multiply in one formula?
Yes. Combine the symbols in one formula, beginning with =. Use parentheses to control the order, such as =(A1+B1)*C1.
Why is Excel showing my formula instead of the answer?
Check whether the cell is formatted as Text or the formula begins with an apostrophe. Set the cell to General and enter the formula again. Also check whether Show Formulas is enabled.
Why does my copied formula change its cell references?
Excel adjusts relative references when you copy a formula. Add dollar signs to references that must stay fixed, such as $B$1.
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.