Excel Command for Subtraction: The Simple Formula Trick
You open Excel. You need to subtract one number from another. Simple, right? Then you search for a “subtract” button and find nothing. No SUBTRACT function. No obvious menu option. Just blank cells staring back at you.
Here’s the good news: subtraction in Excel is one of the easiest things you’ll ever do in the program. You just need to know the right trick, and this article walks you through every version of it, from the two-second basic formula to the tricks most tutorials skip.
Does Excel Have a Subtract Command?
Let’s answer this right away, because it trips up a lot of people. Excel has a SUM function for addition. It has an AVERAGE function for averages. But it doesn’t come with a ready-made SUBTRACT function.
Instead, Excel uses the minus sign (–) as its subtraction command. That’s it. That’s the whole secret. Every subtraction task in Excel, no matter how complex, comes back to this one symbol.
Think of the minus sign as Excel’s version of a subtract button. It works in every cell, every formula, and every version of Excel, from the desktop app to Excel Online.
How to Subtract Two Numbers in Excel
Let’s start with the basics. Say you want to subtract 5 from 20.
- Click on any empty cell.
- Type an equal sign: =
- Type the first number, then a minus sign, then the second number: =20-5
- Press Enter.
Excel instantly shows the result: 15. Every formula in Excel begins with an equal sign. Without it, Excel treats your entry as plain text, not a calculation.
How to Subtract Cell Values Instead of Typed Numbers
Typing numbers directly into a formula works fine for quick math. But most real spreadsheets store numbers in cells, not typed straight into formulas. This is where cell references come in.
Let’s say cell A1 has the number 100, and cell B1 has the number 40. To subtract B1 from A1:
- Click on cell C1 (or any empty cell).
- Type =A1-B1
- Press Enter.
Excel shows 60. The real advantage here is flexibility. If you change the number in A1 or B1 later, the result in C1 updates automatically. You never have to redo the math by hand.
How to Subtract Multiple Cells at Once
Sometimes you need to subtract several numbers from one starting value. For example, you might want to subtract three different expenses from a budget.
You could write a long formula like this:
=A1-A2-A3-A4
That works, but it gets messy with long lists. A cleaner Excel subtraction formula uses the SUM function to add up everything you want to subtract, then removes that total from the starting number:
=A1-SUM(A2:A4)
This tells Excel to add up cells A2 through A4, then subtract that total from A1. It’s faster to type, easier to read, and much simpler to fix if you add more rows later.
How to Subtract an Entire Column or Row
Say you have prices in column A and discounts in column B, and you want the final prices in column C.
- Click on cell C1.
- Type =A1-B1 and press Enter.
- Click on cell C1 again, then click and drag the small square in the bottom right corner down through the rest of the column.
Excel automatically adjusts the formula for each row, so C2 becomes =A2-B2, C3 becomes =A3-B3, and so on. This is called a relative reference, and it’s one of the most useful shortcuts in the entire program.
If you need to subtract the same fixed number from every row instead, lock that cell using dollar signs. For example, =A1-$B$1 keeps B1 fixed even as you drag the formula down. This is called an absolute reference.
If you’re adding new rows to your data as you go, it also helps to know the shortcut key for inserting a row in excel. It’s faster than right-clicking every time, and it keeps your subtraction formulas intact as the sheet grows.
How to Subtract Percentages in Excel
Subtracting a percentage from a number trips up a lot of people, because you can’t just subtract the percentage number directly. If you want to reduce 200 by 15 percent, here’s the formula:
=200-(200*15%)
Or, using cell references, if A1 holds 200 and B1 holds 15%:
=A1-(A1*B1)
The parentheses matter here. They tell Excel to calculate the percentage of the number first, then subtract that result from the original number, following the normal order of operations.
How to Subtract Dates and Times (Without Getting a Weird Error)
This is where most tutorials stop short, but it’s one of the most common everyday uses for subtraction in Excel: figuring out how many days passed between two dates, or how much time an event took.
Subtracting dates: If A1 has one date and B1 has an earlier date, =A1-B1 gives you the number of days between them. Excel treats dates as numbers behind the scenes, so this works automatically.
Subtracting times: The same formula works for time values, but there’s a catch. If your result is negative, or if the format doesn’t match, Excel often displays a row of pound signs like ##### instead of an actual number.
To fix this, right-click the result cell, choose Format Cells, and switch the format to Number or General instead of Time. This one small step solves a problem that confuses even experienced spreadsheet users.
Common Subtraction Errors in Excel (and How to Fix Them)
After spending years working with spreadsheets, I’ve noticed the same handful of mistakes come up again and again. Here’s what usually goes wrong, and the fix for each one.
- #VALUE! error: This shows up when one of the cells in your formula contains text instead of a number. Check for stray letters, spaces, or symbols in the cell.
- Wrong result with no error message: This usually means a cell is formatted as text even though it looks like a number. Reformat the cell as Number and re-enter the value.
- ##### symbols instead of a number: The column is too narrow, or the cell format doesn’t match the result (common with date and time subtraction). Widen the column or change the format.
- #REF! error: A cell used in your formula was deleted. You’ll need to rebuild the formula using a current cell.
Bonus Trick: Subtract Without Writing a Formula
If formulas feel intimidating, Excel has a lesser-known feature called Paste Special that lets you subtract without typing a single equal sign.
- Type the number you want to subtract into any empty cell, then copy it (Ctrl+C).
- Select the range of cells you want to subtract that number from.
- Right-click and choose Paste Special.
- Under “Operation,” select Subtract.
- Click OK.
Excel instantly subtracts that number from every cell you selected, all at once. This trick is especially handy when you’re cleaning up a large report and don’t want to write dozens of individual formulas.
Quick Reference: Excel Subtraction Formulas
- Subtract two numbers: =20-5
- Subtract cell values: =A1-B1
- Subtract multiple cells: =A1-SUM(A2:A4)
- Subtract with a fixed cell: =A1-$B$1
- Subtract a percentage: =A1-(A1*B1)
- Subtract dates: =A1-B1 (formatted as Number)
Frequently Asked Questions
What is the Excel command for subtraction?
Excel doesn’t have a single named command for subtraction the way it has SUM for addition. Instead, the minus sign (-) acts as the subtraction operator inside a formula, such as =A1-B1.
Can I subtract without using a formula?
Yes. Use the Paste Special feature with the Subtract operation, described above. It lets you subtract a value from many cells at once without typing any formula.
Why does my subtraction formula show a negative number when it shouldn’t?
This usually means the cell references are in the wrong order. Excel always subtracts the second value from the first, so =A1-B1 gives a different result than =B1-A1.
How do I subtract in Excel across multiple sheets?
Include the sheet name before the cell reference, separated by an exclamation mark. For example, =Sheet1!A1-Sheet2!A1 subtracts a value on Sheet2 from a value on Sheet1.
Is there a keyboard shortcut for subtraction in Excel?
There’s no dedicated shortcut key, but you can speed things up by using AutoSum’s dropdown arrow, or by simply typing the formula directly, since the minus sign on your keyboard is the fastest method available. If you want to work faster overall, it’s worth learning a few more Microsoft Excel shortcuts that cover copying, navigating, and formatting too.
Does this subtraction formula work in Google Sheets too?
Yes, Google Sheets uses the same minus sign approach for subtraction, so a formula like =A1-B1 works exactly the same way there. Sheets also has its own set of lesser-known tools worth exploring, covered in this list of Google Sheets hidden functions.
Final Thoughts
Subtraction in Excel isn’t complicated once you know the trick: the minus sign is your command, and everything else builds on top of that one simple idea. Whether you’re subtracting two numbers, an entire column, a percentage, or a set of dates, the same logic applies every time.
Start with the basic formula, get comfortable with cell references, and the other methods, like Paste Special and locked references, will start to feel just as natural.
Formulas aren’t the only trick hiding inside Excel, either. The program has a small excel hidden game tucked away too, worth a two-minute break the next time you need one.
For more official guidance straight from Microsoft, you can also check their support page on subtracting numbers in Excel.
