# Excel Subtraction Formula: How to Subtract in Excel

Subtraction in Excel does not use a dedicated function. You write an **Excel subtraction formula** with the minus sign (`-`) between the values you want to subtract, and Excel returns the difference. This works for typed numbers, cell references, ranges, and whole columns.

## Quick Answer

- Start every formula with `=` and use the minus operator: `=A2-B2`.
- Subtract cell references, not typed numbers, when your data may change later.
- To subtract several values, chain the operator: `=A2-B2-C2`.
- To subtract totals, use `=SUM(A2:A6)-SUM(B2:B6)`.
- Excel has no `SUBTRACT` function. The minus sign is the subtraction operator.

## Before You Start

A subtraction formula needs three things: an equals sign, at least two values, and a minus sign between them. The equals sign tells Excel that what follows is a calculation, not text. Without it, Excel treats `A2-B2` as a label and displays it as typed.

Order matters. Excel evaluates subtraction from left to right, so `=10-3-2` returns 5, not 9. If you need to subtract a group first, wrap that group in parentheses: `=10-(3-2)` returns 9.

Cell references are the safer choice for real work. If you type `=12500-8300`, the result is fixed at 4200 forever. If you type `=A2-B2` and later change the value in A2, the result updates automatically. That behavior is the main reason to build formulas instead of doing mental math.

If you are new to writing formulas at all, the structure is the same for every operator. Our guide to how to make a formula in Excel covers the equals sign, cell references, and order of operations in more detail.

## Step by Step

1. Click the cell where you want the result to appear.
2. Type `=` to start the formula.
3. Click the first cell or type its reference, for example `A2`.
4. Type `-` (the minus sign, usually next to the 0 key).
5. Click the second cell or type its reference, for example `B2`.
6. Press Enter. Excel calculates the difference and moves to the next cell.
7. To apply the same formula down a column, select the cell, drag the small square at its bottom right corner down, or copy the cell and paste it into the cells below. Excel adjusts the row numbers automatically.

That last point is worth understanding. When you copy `=A2-B2` from row 2 to row 3, Excel rewrites it as `=A3-B3`. This is called relative referencing, and it is what makes filling a formula down a column so fast.

## Worked Example

The table below tracks monthly revenue and costs for a small business, with profit calculated in column C.

| Row | A | B | C |
|-----|---|---|---|
| 1 | Revenue | Costs | Profit |
| 2 | 12500 | 8300 | `=A2-B2` -> displays $4,200.00 |
| 3 | 9800 | 7100 | `=A3-B3` -> displays $2,700.00 |
| 4 | 15600 | 10200 | `=A4-B4` -> displays $5,400.00 |
| 5 | 11200 | 8900 | `=A5-B5` -> displays $2,300.00 |
| 6 | 13400 | 9600 | `=A6-B6` -> displays $3,800.00 |
| 7 | Total | `=SUM(B2:B6)` -> displays $44,100.00 | `=SUM(A2:A6)-SUM(B2:B6)` -> displays $18,400.00 |

Cell C2 holds `=A2-B2`, which subtracts costs from revenue for the first month and returns 4200. Filling that formula down through C6 produces 2700, 5400, 2300, and 3800 for the remaining rows.

Row 7 takes a different approach. Cell B7 uses `=SUM(B2:B6)` to total the costs, and cell C7 uses `=SUM(A2:A6)-SUM(B2:B6)` to subtract the cost total from the revenue total. That returns 18400, which matches the sum of the five individual profit figures. Both routes give the same answer, and using both is a quick way to check your work.

The dollar signs in the displayed values come from number formatting, not from the formula. The formula itself returns a plain number.

## Other Ways to Do It

**Subtract a constant from a column.** If every row needs the same value removed, put that value in one cell and lock the reference with dollar signs: `=A2-$E$1`. Copying this down keeps the reference pointed at E1 while the row number in A2 changes.

**Subtract across sheets.** Reference another sheet by name: `=Sheet2!A2-B2`. If the sheet name contains spaces, wrap it in single quotes, as in `='Q1 Data'!A2-B2`.

**Subtract dates.** Dates are stored as serial numbers, so `=B2-A2` returns the number of days between two dates. The result may display as a date instead of a number, which you fix by changing the cell format to General or Number. Our article on Excel date formulas walks through that formatting step.

**Subtract a percentage.** To reduce a value by a percentage, multiply instead of subtracting twice: `=A2*(1-0.15)` lowers A2 by 15 percent. The decrease by percentage formula guide covers the variations.

**Use Paste Special.** If you have a column of values and want to subtract a matching column without writing formulas, copy the second column, select the first, and use Paste Special with the Subtract operation. This overwrites the original values, so work on a copy if you may need the originals.

**Use SUM with negative numbers.** `=SUM(A2:A6,-B2,-B3)` adds the range and then adds the negatives of B2 and B3, which is mathematically the same as subtracting them. It is useful when the values to subtract are scattered.

## Troubleshooting

**The formula shows as text.** The cell is probably formatted as Text, or the formula is missing its leading equals sign. Select the cell, check the formula bar, and reformat the cell as General before re-entering the formula.

**You see `#VALUE!`.** One of the referenced cells contains text instead of a number. Check for stray spaces, apostrophes, or labels mixed into your numeric column.

**You see `#####`.** The column is too narrow to display the result. Widen the column. The value itself is fine.

**The result is a date.** Excel inherited a date format from the cells you referenced. Change the result cell's format to General or Number.

**The result is wrong after copying.** You likely needed an absolute reference. Add dollar signs to the part that should not shift, such as `$E$1`.

**Circular reference warning.** The formula refers to its own cell, directly or through a chain. Move the formula to a different cell.

## Common Mistakes

- **Typing numbers instead of cell references.** `=12500-8300` never updates. Use `=A2-B2` so the result follows your data.
- **Forgetting the equals sign.** Excel stores `A2-B2` as text. Always start with `=`.
- **Ignoring order of operations.** `=A2-B2-C2` and `=A2-(B2-C2)` give different answers. Use parentheses when you mean to group.
- **Mixing text and numbers in one column.** A single label like "n/a" in a numeric column turns the whole subtraction into `#VALUE!`. Keep numeric columns numeric.
- **Pasting a dash or typographic minus sign instead of the hyphen-minus key.** A dash pasted from a word processor can look identical but break the formula. Retype the operator directly in Excel.
- **Subtracting in the wrong direction.** `=B2-A2` gives the negative of `=A2-B2`. Decide which value is the starting point before you fill the column.

## Limitations

Subtraction formulas return a static number for each row. They do not group, filter, or summarize data on their own. If you need profit by region or by quarter, you need a pivot table or a function like SUMIF, not a column of minus signs.

The minus operator also cannot subtract one range from another directly. `=A2:A6-B2:B6` does not work as a single formula in older Excel versions, and even in modern versions it relies on dynamic array behavior that many users find confusing. The reliable pattern is to subtract cell by cell, or to subtract sums with `=SUM(A2:A6)-SUM(B2:B6)`.

Finally, subtraction is unforgiving about data types. Text, blank cells, and error values propagate through the calculation. A blank cell is treated as zero, which can silently understate a result if the blank was meant to hold data.

## Frequently Asked Questions

### Is there a subtract function in Excel?

No. Excel provides SUM, PRODUCT, and many other functions, but no SUBTRACT function. Subtraction is done with the minus operator, as in `=A2-B2`. If you search for a subtract function, you will not find one in the function list.

### How do I subtract multiple cells in one formula?

Chain the minus operator: `=A2-B2-C2-D2`. Excel evaluates left to right. If you need to subtract a group first, use parentheses, as in `=A2-(B2+C2)`. For long lists, subtracting two SUM results is usually cleaner.

### How do I subtract a whole column from another column?

Enter the formula in the first row of the result column, then fill it down. Excel adjusts the row references for each row automatically. If you are subtracting a fixed value, lock that reference with dollar signs before filling.

### Why does my subtraction formula show a date?

The cells you referenced are formatted as dates, and Excel carried that format into the result. Select the result cell, open the number format menu, and choose General or Number. The underlying value was correct all along.

### Can I subtract in Excel without a formula?

Yes, in a limited way. You can use Paste Special with the Subtract operation to subtract one range of values from another in place. This replaces the original numbers with the results, so keep a backup copy if you might need the source values. For anything you may want to adjust later, a formula is the better choice.

If you want to build out a full set of arithmetic formulas, the same operator logic applies to the other operations. Our guides to the multiplication formula and the division formula follow the same structure, and Excel formula basics covers the shared rules for all of them.

## References

This article draws on the standard references listed under Further Reading.

## Further Reading

- [Broman KW, Woo KH (2018). Data Organization in Spreadsheets. The American Statistician](https://doi.org/10.1080/00031305.2017.1375989)
- [Ziemann M, Eren Y, El-Osta A (2016). Gene name errors are widespread in the scientific literature. Genome Biology](https://doi.org/10.1186/s13059-016-1044-7)
- [Microsoft Support: Excel help and learning](https://support.microsoft.com/en-us/excel)
- [McCullough B, Heiser DA (2008). On the accuracy of statistical procedures in Microsoft Excel 2007. Computational Statistics & Data Analysis](https://doi.org/10.1016/j.csda.2008.03.004)
- [Abeysooriya M, Soria M, Kasu MS et al. (2021). Gene name errors: Lessons not learned. PLOS Computational Biology](https://doi.org/10.1371/journal.pcbi.1008984)
- [Wilson G, Bryan J, Cranston K et al. (2017). Good enough practices in scientific computing. PLOS Computational Biology](https://doi.org/10.1371/journal.pcbi.1005510)

## Related Articles

- [Multiplication Formula in Excel: How to Multiply Cells](/blog/data-analysis/multiplication-formula-excel)
- [Excel Date Formulas: How to Add, Subtract and Format Dates](/blog/data-analysis/excel-date-formulas-add-subtract-format)
- [Division Formula in Excel: How to Divide Cells and Columns](/blog/data-analysis/division-formula-in-excel)
- [How to Make a Formula in Excel (Step by Step)](/blog/data-analysis/how-to-make-formula-in-excel)
- [How to Calculate Standard Deviation in Excel](/blog/data-analysis/how-to-calculate-standard-deviation-in-excel)