Learning how to subtract in Excel is essential for anyone tracking budgets, calculating variances, or analyzing data. Unlike addition, Excel doesn't have a built-in "MINUS" function for basic cell subtraction. Instead, you use a simple arithmetic formula with a minus sign (-) or combine functions like SUM with negative values.
You can subtract numbers directly in a cell, find the difference between two columns, or subtract a single number across an entire dataset using absolute cell references. This guide breaks down every method clearly, complete with step-by-step instructions and common error fixes.
Understanding the Basics of Excel Subtraction
Excel handles basic subtraction through standard arithmetic operators rather than a dedicated function name. Every formula in Excel starts with an equal sign (=). When you want to subtract values, you type the equals sign, followed by the first number or cell reference, a minus sign, and the second number or cell reference.
For example, typing =100-25 directly into a cell and pressing Enter gives you 75. But spreadsheets are most powerful when you use cell coordinates instead of static numbers. If cell A1 contains 100 and cell B1 contains 25, typing =A1-B1 subtracts the value in B1 from the value in A1. If you change the number in A1 later, Excel updates the result automatically.
How to Subtract Two Cells
Subtracting one cell from another takes only a few seconds. Follow these steps to set up your first cell subtraction formula:
- Click on the cell where you want the result to appear.
- Type an equals sign (
=). - Click on the first cell you want to subtract from (the minuend), or type its reference (e.g.,
A2). - Type a minus sign (
-). - Click on the cell containing the value you want to take away (the subtrahend), or type its reference (e.g.,
B2). - Press Enter.
Your formula should look like =A2-B2. Excel calculates the difference instantly.
Subtracting Multiple Cells and Columns
Real-world spreadsheets often require subtracting multiple values from a starting total, such as deducting various expenses from a monthly income pool.
If you want to subtract several cells from a base cell in sequence, chain them together in a single formula:
=A2-B2-C2-D2
Excel evaluates this formula from left to right. It takes the value in A2, subtracts B2, subtracts C2 from that new subtotal, and finally subtracts D2.
If you need to subtract an entire column of numbers from a starting figure, you can combine the SUM function to add up all the deductions first, then subtract that sum from your initial total:
=A2-SUM(B2:B10)
This method keeps your formulas clean and saves you from writing long chains of minus signs when dealing with large data ranges.
Using Absolute Cell References to Subtract a Constant
Often, you need to subtract the same fixed number—such as a tax rate, a flat discount, or a fixed monthly fee—from an entire column of different values. If you write a standard formula like =A2-B1 and drag it down, Excel shifts both references, turning the next row into =A3-B2, which breaks your calculation.
To fix this, use an absolute cell reference by adding dollar signs ($) around the column and row of the fixed cell.
- Enter your formula in the first row, locking the fixed cell:
=A2-$C$1. - Hover your mouse over the bottom-right corner of the cell until the cursor turns into a small black cross (the fill handle).
- Click and drag the formula down the column.
The reference A2 changes to A3, A4, and A5 as it moves down, but $C$1 remains locked, subtracting the exact same constant from every row.
Subtracting Dates and Times in Excel
Excel stores dates and times as sequential serial numbers, which means you can subtract them just like regular numbers to find durations.
To find the number of days between two dates, subtract the earlier date from the later date:
=B2-A2
If cell B2 contains 2026-12-31 and cell A2 contains 2026-01-01, Excel returns 364 days. Make sure the result cell is formatted as "General" or "Number" rather than "Date", otherwise Excel might display the resulting serial number as a calendar date.
For tracking hours worked or elapsed time, use a similar subtraction formula:
=B2-A2
If your result displays incorrectly, right-click the cell, open Format Cells, and select a time format like 13:30 or [h]:mm:ss to show total elapsed hours correctly.
Common Subtraction Errors and How to Fix Them
When working with subtraction formulas, you might occasionally run into error codes. Here is what they mean and how to resolve them:
- #VALUE! Error: This happens when your formula tries to subtract text instead of numbers. Check your cells for accidental spaces, hidden characters, or text formatting. You can force Excel to recognize text numbers by multiplying by 1 or wrapping them in the VALUE function.
- ##### Display: This isn't an error code; it simply means the column isn't wide enough to display the number. Double-click the right boundary of the column header to auto-fit the width.
- Unexpected Negative Numbers: If your subtraction yields a negative result when you expected a positive one, check the order of your cell references. You likely subtracted a larger number from a smaller one.
Frequently Asked Questions
Is there a MINUS function in Excel?
No. Unlike addition (SUM) or multiplication (PRODUCT), Excel does not feature a dedicated MINUS function. You must use the minus arithmetic operator (-) or combine SUM with negative values.
How do I subtract a percentage in Excel?
To decrease a number by a specific percentage, multiply the number by 1 minus that percentage. For example, to subtract 15% from the value in cell A2, use =A2*(1-0.15) or simply =A2*0.85.
Can I subtract across multiple worksheets?
Yes. You can reference cells on different sheets by preceding the cell name with the sheet name and an exclamation point, such as =Sheet1!A2-Sheet2!A2.
Why won't my subtraction formula calculate automatically?
If your formula displays the text of the formula instead of the calculated answer, automatic calculation might be turned off. Go to the Formulas tab on the ribbon, click Calculation Options, and select Automatic.
