Subtracting two numbers in Excel provides a clear way to calculate differences between values quickly. You can use simple formulas or direct references to generate accurate results in seconds.
This guide explains how to subtract 2 numbers in Excel with practical examples and ready-to-use patterns.
| Operation Type | Excel Syntax | Example | Result |
|---|---|---|---|
| Direct subtraction | =number1 - number2 | =100 - 35 | 65 |
| Cell reference subtraction | =A2 - B2 | =A2 - B2 | Dynamic result based on cell values |
| Subtract with cell references and constants | =A2 - 10 | =A2 - 10 | Value in A2 minus 10 |
| Nested subtraction in a formula | =A2 - B2 - C2 | =A2 - B2 - C2 | Sequential difference across multiple cells |
Basic Subtraction Syntax
Use the minus sign (-) to construct a subtraction formula in any cell. Start with an equal sign so Excel recognizes the entry as a formula.
For example, typing =10 - 4 returns 6. You can also reference other cells, such as =C5 - D5, which updates automatically when the source values change.
Keep the formula simple and avoid extra spaces that might cause confusion when reading or editing the sheet.
Using Cell References
Cell references make your formulas flexible and easier to maintain. Instead of hardcoding numbers, point to the cells that contain the values you want to subtract.
If cell A1 holds 200 and cell B1 holds 80, the formula =A1 - B1 returns 120. Updating either A1 or B1 immediately refreshes the result without editing the formula.
This approach is essential when you work with large datasets or build models that require frequent updates.
Subtracting Across Rows and Columns
You can apply subtraction formulas across entire rows or columns to compare corresponding values. Copying the formula down a column preserves relative references, so each row adjusts automatically.
For instance, if you have expenses in column E and income in column F, placing =F2 - E2 in G2 and dragging down calculates profit or loss for each row consistently.
Use fill handle or paste formulas carefully to ensure references move as intended across the worksheet.
Handling Negative Results
When the subtrahend is larger than the minuend, Excel returns a negative number. This behavior is expected and useful for identifying deficits or directional changes.
To highlight negative outcomes, apply conditional formatting rules such as data bars or color scales. You can also wrap the formula with IF to display custom messages, for example, =IF(A2-B2
Understanding how negatives appear helps you interpret results accurately in financial and analytical contexts.
Best Practices for Subtraction Formulas
- Always start formulas with an equal sign to activate calculation.
- Use cell references instead of hardcoded numbers for flexibility.
- Apply consistent number formatting to avoid confusion.
- Use absolute references ($A$1) for constants that should not change.
- Test edge cases, such as negative results or blank cells, in your data.
FAQ
Reader questions
How do I subtract two numbers located in different sheets?
=Sheet1!A1 - Sheet2!B1
Can I subtract percentages directly using this method?
=A2 - B2 works with decimal percentages such as 0.15, and Excel will return the correct difference.
What happens if I subtract text formatted as numbers? =A2 - B2 may return a #VALUE! error; convert text to numbers using VALUE or Paste Special as needed. How do I keep a constant number while subtracting a series of values?
= $A$1 - B2 locks the constant reference so copying down only changes the subtrahend.