Excel has no SUBTRACT function. You subtract with the minus sign (the hyphen key) inside a formula: click an empty cell, type =A2-B2, and press Enter. Swap in your own cell addresses or plain numbers, such as =250-75. These steps cover Excel for Microsoft 365 and Excel 2021 and 2024 on Windows and Mac. The basic formulas also work in older desktop versions, with one exception noted below.
What you need and a few terms
All you need is a workbook with numbers in it, or an empty one where you can type some. A few words come up again and again below, so here is what they mean.
- Formula: anything you type into a cell that starts with an equal sign (
=). Without that sign, Excel treats what you typed as plain text or a number and does no math. - Cell reference: the column letter and row number that name a cell, like
B4. When a formula uses references instead of typed numbers, the result changes on its own whenever those cells change. - Operator: the symbol that tells Excel what math to do. The minus sign handles subtraction, and the same symbol in front of a single value (as in
=-1) makes it negative. - Fill handle: the small square at the bottom-right corner of the selected cell. Dragging it copies a formula into neighboring cells.
- Absolute reference: a reference with dollar signs, such as
$E$1, that stays pointed at the same cell when you copy the formula somewhere else.
Subtract one cell from another
This is the method to learn first, because nearly every other subtraction trick in Excel builds on it. Say the starting amount is in A2 and the amount to take away is in B2.
- Click the cell where the answer should appear, for example C2.
- Type an equal sign (
=). Excel now knows you are building a formula, and the formula bar above the grid shows what you type. - Click cell A2, or type
A2. The address appears in the formula. - Type a minus sign using the hyphen key on the main keyboard or the minus key on the number pad. Both produce the same character.
- Click cell B2, or type
B2. The cell now reads=A2-B2. - Press Enter (Return on many Mac keyboards). The cell shows the difference, and the formula itself stays visible in the formula bar whenever you select C2 again.
Order matters. Excel always takes the value on the right of the minus sign away from the value on the left, so =B2-A2 gives the same size answer with the opposite sign. If you change the number in A2 or B2 later, C2 updates immediately, which is the main reason to use references instead of typed numbers.
Other ways to subtract, and which one to pick
The cell-minus-cell formula covers most needs. The variations below solve specific situations: quick math with no data, long lists of deductions, whole columns, a fixed amount taken off many cells, and changes you want baked into the data.
Type the numbers right into the formula
For a one-off calculation, skip the cells and type values directly: =1200-345 returns 855. You can keep going in the same cell, so =50-10-5-3 returns 32. Excel works through a chain of minus signs from left to right. The drawback is that nothing updates automatically, because the numbers are locked inside the formula, so this approach suits scratch math rather than a sheet you will reuse.
Take several values away from one total
When a starting amount has a handful of deductions, you have two good options. A chain such as =B1-B2-B3-B4 is easy to read when there are only three or four cells. Once the list grows, add the deductions with SUM and subtract that total in one step: =B1-SUM(B2:B10). The SUM version stays short no matter how many deductions there are, and it is harder to skip a cell by accident.
A third route is to store the deductions as negative numbers and add everything: =SUM(100,-32,15,-6) returns 77. This is handy for ledgers where money out is already entered as negative. For more layouts, including deductions spread across rows, see subtracting multiple cells in Excel.
Subtract one column from another, row by row
Write the formula once in the first data row, then copy it down. Excel adjusts the row numbers as it copies, so =B2-C2 in row 2 becomes =B3-C3 in row 3, and so on.
- In D2, type
=B2-C2and press Enter. - Click D2 again so it is selected.
- Point at the fill handle in the corner of D2 until the pointer becomes a thin cross, then drag down to the last row of data.
- Release the mouse. Each row now shows its own difference.
On Windows there is a keyboard alternative: select D2 together with the empty cells below it and press Ctrl+D, which fills the top cell’s contents down through the selection. A deeper walkthrough, with tips for long tables, is in how to subtract two columns in Excel.
One formula for a whole column (Microsoft 365, Excel 2021 and 2024)
Excel for Microsoft 365, Excel 2021 and Excel 2024 support dynamic arrays, which means a single formula can return many results. Type =B2:B6-C2:C6 in D2 and press Enter, and Excel fills D2 through D6 with five answers. This is called spilling, and a thin border appears around the results. Only the first cell holds the formula, so edit D2 if you need to change it. In versions without dynamic array support, use the copy-down method instead.
Take the same number off every cell
Suppose a flat $15 fee comes off every amount in column B, and the fee lives in cell E1. If you type =B2-E1 and copy it down, row 3 becomes =B3-E2, which points at an empty cell and gives the wrong answer. Lock the fee cell with dollar signs instead: =B2-$E$1. Now the B reference moves as you copy, but the fee reference does not.
You don’t have to type the dollar signs yourself on Windows. Click inside the reference in the formula bar and press F4, which cycles through the absolute and relative combinations. On a Mac, typing the two dollar signs works every time. You could also write the fee into the formula, as in =B2-15, but then changing the fee means editing every formula.
Subtract in place with Paste Special
Sometimes you want to change the numbers themselves rather than show results in a new column, for example knocking 10 units off every stock count. Paste Special can do that with no formulas. Warning: this overwrites the original values, so copy the column to a spare spot or save a backup before you start.
- Type the amount to subtract (10 in this example) in any empty cell.
- Select that cell and copy it.
- Select the cells you want to reduce.
- On the Home tab, select the arrow under Paste, then choose Paste Special.
- Under Operation, choose Subtract. To leave the target cells’ formatting alone, also choose Values under Paste.
- Select OK. Each selected cell drops by 10, and the cells still contain plain numbers, not formulas.
- Delete the helper cell from step 1.
On Windows, Ctrl+Alt+V opens the same Paste Special box. Because the change is permanent, Paste Special is best for one-time corrections. If the amount might change again next month, a formula column is the safer choice.
Dates, times and percentages
The same minus sign works on dates and times, because Excel stores them as numbers behind the scenes. A date is a count of days, so =B2-A2 with a later date in B2 returns the days between them. A time is a fraction of a day, which is why subtracting two times can show a small decimal once the cell format is changed to General. If a date subtraction displays another date instead of a number of days, change the result cell’s format to General or Number on the Home tab. For working days, months and years, see subtracting dates in Excel.
Percentages are just numbers formatted with a percent sign: a cell showing 20% holds 0.2. Subtracting one percentage from another, as in =B2-C2, works normally. To reduce a value by a percentage, multiply instead of subtracting the percentage directly: =B2*(1-C2) takes 20% off when C2 holds 20%. Writing =B2-C2 there would take away 0.2, not a fifth of the value.
Worked example: a small team budget
Here is a fictional sheet tracking three people’s spending against their monthly budgets. Column D shows what each person has left, using =B2-C2 in D2, copied down to D4.
| Row | A: Name | B: Budget | C: Spent | D: Left (formula) | D: Result |
|---|---|---|---|---|---|
| 2 | Alex | 500 | 380 | =B2-C2 | 120 |
| 3 | Jordan | 650 | 702 | =B3-C3 | -52 |
| 4 | Priya | 400 | 400 | =B4-C4 | 0 |
| 5 | Team | =SUM(B2:B4) | =SUM(C2:C4) | =B5-C5 | 68 |
A few things to notice. Jordan’s result is negative because spending passed the budget, and Excel reports that honestly rather than stopping at zero. Priya’s zero is correct, not an error. The team row adds each column with SUM (1,550 budgeted, 1,482 spent) and then subtracts the totals, giving 68. You could reach the same 68 by adding column D with =SUM(D2:D4), a handy cross-check that the row formulas are right.
Now suppose the company takes a $25 software fee from each person and that fee sits in F1. A new column E with =D2-$F$1, copied down, would show 95, -77 and -25. The dollar signs keep every row pointed at F1.
When the answer looks wrong
Most subtraction problems in Excel come from a short list of causes. Match what you see to the list below.
The formula shows up as text
If the cell literally displays A2-B2, the equal sign is missing. Every formula has to begin with =. Select the cell, add the sign at the start, and press Enter.
#VALUE! appears
The minus operator can’t calculate cells that contain text, spaces or hidden spaces. Check the cells your formula points to and clear any stray characters. Another fix is to lean on a function, since functions such as SUM tend to skip text instead of failing. On Windows, a rarer cause is a system setting: if the List separator in your region settings is set to the minus sign, even =A2-B2 can return #VALUE!. Microsoft’s page on correcting a #VALUE! error walks through that setting.
Numbers stored as text
Data pasted from a website or another program sometimes arrives as text that only looks like numbers. Excel usually marks these cells with a small green triangle in the corner. Select the cells, open the warning icon that appears beside them, and choose Convert to Number.
A negative result you didn’t expect
A negative answer usually means the references are in reverse order. Swap them so the larger starting value comes first. If you only care about the size of the gap and never its direction, wrap the subtraction in ABS, which returns a number without its sign: =ABS(A2-B2) gives 52 whether the difference is 52 or -52.
The math is right but the total is off
Excel does multiplication and division before addition and subtraction, and it works through plus and minus signs from left to right. So =100-20+10 returns 90, while =100-(20+10) returns 70. Add parentheses around anything that should be worked out first.
Results go wrong after copying
If the first row is right and later rows are wrong, a reference that should have stayed fixed moved during the copy. Add dollar signs to that reference, as in $E$1, then copy the formula down again.
#SPILL! appears
This only happens with the one-formula column method. Something, even a single typed value, is sitting in the cells where the results need to go. Clear or move the blocking data and the results fill in.
Double-check the result, or undo it
A quick sanity check catches most slips before anyone else sees the sheet.
- Read the formula: select a result cell and look at the formula bar to confirm it points at the cells you meant.
- Show every formula at once: on the Formulas tab, select Show Formulas, or press Ctrl+` (the grave accent key) on Windows. Select it again to switch back to results.
- Use the status bar: select a group of cells and the bar at the bottom of the window shows their Sum, which lets you compare totals without writing another formula.
- Try an easy number: temporarily type a round value like 100 in a source cell and confirm the answer changes the way you expect.
To reverse a mistake, use Undo right away: press Ctrl+Z on Windows or select the Undo button. This matters most after Paste Special, since that change overwrites values. If you saved afterward and Undo is no longer available, restore from the backup copy, or reverse the operation by running Paste Special again with Add and the same amount.
Quick answers about subtracting in Excel
Is there a MINUS function in Excel?
No. Excel uses the minus operator for all subtraction, and typing =MINUS(A2,B2) returns a #NAME? error because Excel doesn’t recognize the name. Google’s spreadsheet app is different: it does include one, covered in using MINUS in Google Sheets. If you share files between the two, stick with the minus sign so the formula works in both.
Can I subtract a value on another sheet?
Yes. Put the sheet name and an exclamation point before the cell address, as in =B2-Sheet2!B2. If the sheet name has spaces or other non-letter characters, wrap it in single quotes: =B2-'Q1 Sales'!B2. You can also type the start of the formula, click the other sheet’s tab, click the cell, and press Enter, and Excel writes the reference for you.
What happens if I subtract a negative number?
Two minus signs cancel out, so the value gets added. If B2 holds -40, then =100-B2 returns 140. This catches people who record refunds or credits as negative numbers and then subtract them.
Why does my subtraction show a date?
The result cell picked up a date format, often because one of the source cells was a date. Change the cell’s format to General on the Home tab and the plain number appears.
Do blank cells break a subtraction?
A truly empty cell is normally treated as zero, so =A2-B2 with B2 empty just returns A2. A cell that only looks empty but holds a space is different, and that is a common source of #VALUE!.
Where to go next
Open a blank sheet, type two numbers in A2 and B2, and build =A2-B2 in C2. Then copy it down a few rows and add a locked reference with dollar signs. Once those two moves feel natural, every other subtraction task in Excel, from date gaps to budget columns, is a small variation on them.