Quick Answer: The Excel Subtraction Formula
To subtract in Excel, use the minus operator (–) between two values or cell references: =A1-B1 This is the fundamental formula that subtracts the value in B1 from A1. No other Excel function is required for basic subtraction—the minus operator is all you need. If you want the related percent-movement version, see Excel Percentage Change Formula.
Related reading: Learn more about Excel percentage change formulas to calculate growth, decline, and year-over-year performance with the =(New-Old)/Old formula.
Quick-Reference: 5 Common Subtraction Scenarios
| Scenario | Formula | Example | Result |
|---|---|---|---|
| Basic subtraction | =A1-B1 | =10-5 | 5 |
| Subtract multiple cells | =SUM(A1,-B1,-C1) | =SUM(100,-20,-5) | 75 |
| Subtract from a total | =SUM(A1:A10)-B1 | =SUM(A1:A10)-100 | Remaining total |
| Subtract a percentage | =A1*(1-B1) | =100*(1-0.2) | 80 (20% reduction) |
| Subtract with negative | =A1-(-B1) or =A1+B1 | =10-(-5) | 15 |
Understanding Basic Excel Subtraction
Excel subtraction is a fundamental skill for financial analysis and data manipulation. The minus sign (–) is the only operator you need to subtract one value from another.
The Role of the Minus Sign
The minus sign (–) is the key to subtraction in Excel. When you subtract in Excel, you always start with an equal sign (=) to tell Excel you’re entering a formula, then use the minus sign to indicate subtraction.
Basic examples:
=10-5→ Result: 5=100-20-5-3→ Result: 72 (Excel performs these subtractions from left to right)
Simple Subtraction with Cell References
Cell references are what make Excel powerful. Instead of using fixed numbers, you reference cells containing your data:
To subtract using cell references:
- Type
= - Click the cell with your first number
- Type
– - Click the cell with the number you want to subtract
Example: If A1 contains 100 and A2 contains 25, your formula is =A1-A2, which returns 75.
You can also mix cell references and fixed numbers: =A1-15 subtracts 15 from whatever value is in A1.
Related reading: Learn more about Excel percentage change formulas to calculate growth, decline, and year-over-year performance with the =(New-Old)/Old formula.
Subtracting Multiple Cells
When working with large datasets, you often need to subtract multiple cells. Here are the most efficient methods:
Method 1: Using SUM with Negative Values
To subtract multiple cells from one value, use the SUM function with negative values:
=SUM(A1,-B1,-C1,-D1)This subtracts B1, C1, and D1 from A1 in a single, clean formula. It’s especially useful for calculating net profits after deducting multiple expenses.
Why use SUM? It’s more readable and flexible than chaining minus operators. You can easily add or remove items without rewriting the entire formula.
Method 2: Subtracting a Range
To subtract the sum of an entire range from a cell:
=A1-SUM(B1:B10)This subtracts the total of cells B1 through B10 from A1. Perfect for calculating remaining budget after summing all expenses.
Method 3: Array Formulas for Batch Operations
For subtracting corresponding cells in two ranges:
={A1:A10}-{B1:B10}This subtracts each value in B1:B10 from the corresponding cell in A1:A10. Enter as an array formula using Ctrl+Shift+Enter.
Specialized Subtraction Scenarios
Subtracting Dates and Time
Excel treats dates and times as numbers, so subtraction works naturally:
Date difference (in days):
=B1-A1If B1 is 6/22/2026 and A1 is 6/15/2026, the result is 7 (days).
For more precision, use DATEDIF:
=DATEDIF(A1,B1,"d") → Days between dates
=DATEDIF(A1,B1,"m") → Months between dates
=DATEDIF(A1,B1,"y") → Years between datesTime difference (in hours:minutes:seconds):
=B1-A1Format the result cell as “Time” to display the difference.
Percentage-Based Subtractions
To subtract a percentage from a value (e.g., apply a discount):
=A1*(1-B1)Where A1 is the original value and B1 is the percentage in decimal form (10% = 0.1).
Example: If A1=100 and B1=0.2 (20%), the result is 80.
For multiple percentage reductions:
=A1*(1-B1)*(1-C1)This is useful for calculating after-tax profits with multiple tax rates.
Related reading: Learn more about Excel percentage change formulas to calculate growth, decline, and year-over-year performance with the =(New-Old)/Old formula.
Error Handling and Troubleshooting
Dealing with Negative Numbers
Subtracting a negative number is equivalent to addition:
10 - (-5) = 10 + 5 = 15In Excel:
- Use parentheses:
=A1-(-B1) - Or, if B1 already contains a negative:
=A1+B1
For complex calculations with multiple negative values, SUM is clearest:
=SUM(A1,-B1,-C1,D1)When Values Are Stored as Text
If your cells contain numbers stored as text, subtraction returns an error. Use the VALUE function to convert text to numbers:
=VALUE(A1)-VALUE(B1)To identify text values: Look for apostrophes at the start or use the ISNUMBER function:
=ISNUMBER(A1)This returns TRUE if A1 is a number, FALSE if it’s text.
Leveraging Absolute and Relative References
Excel has two reference types that control how formulas behave when copied:
Relative References (A1)
The formula adjusts when copied. =A1-B1 becomes =A2-B2 when copied down.
Absolute References ($A$1)
The formula stays fixed. =$A$1-B1 always references A1, even when copied.
Mixed references:
$A1— locks the column (A), but row changesA$1— locks the row (1), but column changes
Tip: Press F4 to cycle through reference types while editing a formula.
Related reading: Learn more about Excel percentage change formulas to calculate growth, decline, and year-over-year performance with the =(New-Old)/Old formula.
Related Articles on Excel Functions
For more on formulas similar to subtraction, explore:
- Excel SUM Formula: Shortcut to Add Cells — Master addition with SUM
- How to Subtract in Excel — Combine subtraction with IF statements
- Excel VLOOKUP vs INDEX-MATCH: Which Should You Use? — Reference and lookup formulas for complex data
Frequently Asked Questions
How do I subtract two cells in Excel?
Use the minus operator: =A1-B1. This subtracts the value in B1 from A1.
What is the formula for subtracting multiple cells?
Use SUM with negative values:
=SUM(A1,-B1,-C1,-D1)This subtracts B1, C1, and D1 from A1 in one formula.
Can I subtract a percentage in Excel?
Yes. Use =A1*(1-B1) where A1 is the original value and B1 is the percentage as a decimal (e.g., 10% = 0.1).
How do I subtract negative numbers correctly?
Subtracting a negative is equivalent to addition:
=A1-(-B1) → equals =A1+B1What if my cells contain text instead of numbers?
Use the VALUE function to extract numbers:
=VALUE(A1)-VALUE(B1)How do I calculate net profit with subtraction?
Use:
=SUM(Revenue)-SUM(Expenses)Can I subtract dates in Excel?
Related reading: Learn more about Excel percentage change formulas to calculate growth, decline, and year-over-year performance with the =(New-Old)/Old formula.
Yes. Simply subtract: =Later_Date-Earlier_Date returns the number of days between them.
Related reading: Learn more about Excel percentage change formulas to calculate growth, decline, and year-over-year performance with the =(New-Old)/Old formula.
Last updated: June 22, 2026 Author: Allen Hoffman
