To subtract one amount from another in Excel, enter a formula with the minus sign: if the first amount is in A2 and the amount to take away is in B2, use =A2-B2. For example, if A2 contains 125 and B2 contains 40, the result is 85.
How Excel subtraction works
Excel uses the hyphen-minus character, -, as its subtraction operator. A formula must begin with an equals sign so Excel knows to calculate it rather than treat it as ordinary text. You can subtract numbers typed directly into a formula, cell values, or a mixture of both. Cell references are usually more useful because the calculation updates when the source amounts change.
Subtraction is directional: the value after the minus sign is taken away from the value before it. Reversing the order changes the result and can make it negative. In a simple balance calculation, put the starting amount first and the amount spent or removed second. Excel recalculates the result when either referenced cell changes.
There is no built-in Excel function named SUBTRACT. For ordinary subtraction, the minus operator is the standard method. Functions such as SUM can be useful for adding values, including negative values, but they are not required just to subtract one amount from another.
Subtract amounts in two cells
Suppose A2 contains a starting balance of 125 and B2 contains a payment of 40. With the starting amount in A2 and the payment in B2, enter =A2-B2 in C2. The result in C2 is 85. The formula remains connected to the source cells, so changing the payment to 50 makes the result 75.
To enter it in Microsoft Excel for Microsoft 365 on Windows:
- Select the cell where you want the answer, such as C2.
- Type the formula, beginning with an equals sign, and press Enter.
- Select the result cell to review the formula in the formula bar, or edit it directly in the cell.
Excel for Mac uses the same formula syntax and general process. In Excel for the web, enter the formula in a cell and press Enter as well. The interface may look different, but the arithmetic does not change.
Subtract several amounts
To deduct more than one amount from a starting amount, place each subtraction in the formula in the order you want it applied. With an opening balance of 500 in B2, a first expense of 75 in C2, and a second expense of 30 in D2, enter =B2-C2-D2 in E2. The result is 395 because 500 minus 75 minus 30 equals 395.
For a longer list of deductions, a formula that subtracts a total can be easier to read. If B2 holds the opening balance and C2:C5 holds four deductions, enter =B2-SUM(C2:C5) in D2. For example, if the deductions are 10, 15, 20, and 5, their total is 50; an opening balance of 200 gives a result of 150. This is still subtraction: SUM adds the deductions together before Excel takes that total away.
Choose the format that makes the calculation easiest to check. A short sequence of deductions can be written with repeated minus signs. A range of many deductions is often clearer with SUM, especially if the list will grow or if you want to see the deducted total in a separate cell.
Subtract a fixed amount from multiple rows
If the same amount needs to be taken away from many values, put the fixed amount in one cell and reference it in each row. For example, if the amounts are in B2:B4 and the fixed deduction is in F1, enter =B2-$F$1 in C2. If B2 is 90 and F1 is 12, C2 returns 78.
The dollar signs in $F$1 make the reference absolute: it stays fixed when you copy the formula down. Drag the fill handle at the lower-right corner of C2 down through C4, or copy and paste the formula into the other result cells. Excel changes the relative reference B2 to B3 and B4, while retaining F1. If you leave off the dollar signs, copying the formula down shifts both references, which may point to the wrong deduction cell.
An absolute reference can also be created while editing a formula by selecting or placing the cursor on the reference and pressing F4 on Windows. On many Mac keyboards, use Command+T or Fn+F4 depending on the keyboard and Excel settings; you can also type the dollar signs yourself. If a shortcut cycles through reference styles differently on your device, manual entry is reliable.
Calculate a price after a percentage discount
A percentage is not the same as a fixed amount. If B2 contains a price of 80 and C2 contains a discount rate of 15%, enter =B2*(1-C2) in D2. The result is 68, because 15% of 80 is 12 and 80 minus 12 is 68. Format C2 as a percentage, or enter 15% directly; entering 15 instead would mean 1,500% unless you adjusted the formula.
This approach calculates the remaining price, not the discount amount itself. To calculate only the discount, use =B2*C2 in D2 with the same cell layout; the result is 12. If you want to show both the discount and the reduced price, use separate result cells and label them clearly. For multiple discounts or rules, check whether the amounts are applied sequentially or to the original price, because those methods can produce different totals.
These are illustrative spreadsheet calculations, not financial, tax, or purchasing advice. Confirm the applicable price, discount, or other terms with the relevant provider when they matter.
Understand negative results and number formats
A negative result simply means the amount being subtracted is larger than the starting amount. With 40 in A2 and 55 in B2, =A2-B2 in C2 returns -15. That can be useful for showing an overspend, shortfall, or difference below zero. It does not automatically mean the formula is broken.
Number formatting changes how a value appears, not the arithmetic stored in the cell. To display a result as currency, select the result cells and choose Home > Number, then select a currency or accounting format from the number-format options. The exact symbol and decimal display depend on the selected format and regional settings. You can use Home > Number to change decimal places or choose another number format.
If you see hash marks instead of a number, the column may be too narrow to display the formatted value. Widen the column or adjust the number format. If negative values are displayed in parentheses, the cell may use an accounting or custom format; check the underlying value in the formula bar before assuming the calculation is wrong.
Common subtraction errors and fixes
When a minus formula does not produce the expected result, check the inputs and references before rewriting the calculation. Common causes include:
- Missing equals sign: A cell entry such as A2-B2 may be treated as text. Start the formula with =.
- Wrong order: A2-B2 and B2-A2 are different calculations. Verify which cell holds the starting amount.
- Numbers stored as text: Imported values may look numeric but be stored as text. Check for leading apostrophes, spaces, or inconsistent import formatting, then convert the values to numbers.
- Unexpected reference after copying: Use dollar signs for a cell that must stay fixed, such as $F$1.
- Formula displayed instead of result: Check whether the cell is formatted as Text. Change it to General or Number, then re-enter the formula. Also check whether Show Formulas is enabled.
- Wrong decimal or currency assumptions: A displayed currency symbol does not convert the value. Confirm the actual number and its units in the source cells.
For a quick check, select the result cell and inspect both the formula bar and the source cells. Confirm that the formula points to the intended rows and that the inputs are numeric. If a formula has been copied across a table, compare its references with a row where the answer is known.
Subtract dates and compare amounts
Excel stores valid dates as serial numbers, so subtracting one date from another returns the number of days between them. With an earlier date in A2 and a later date in B2, enter =B2-A2 in C2. If A2 is January 1, 2026 and B2 is January 10, 2026, the result is 9 days. Format C2 as General or Number if it appears as a date instead of a day count.
For amounts, subtraction is also a straightforward way to calculate a difference between two figures. With an expected amount in A2 and an actual amount in B2, =B2-A2 in C2 returns the variance. A positive result means the actual figure is greater than the expected figure; a negative result means it is lower. Label the two input columns carefully so a reader knows what the sign means.
Frequently Asked Questions
What is the Excel formula for minus?
Use the minus operator between values or cell references. If the values are in A2 and B2, enter =A2-B2 in the cell where you want the difference.
How do I subtract a number from every row?
Store the fixed number in one cell, use an absolute reference such as $F$1 in the formula, and copy the formula down. Keep the row-specific amount as a relative reference so it updates for each row.
Can I subtract a range of cells from one amount?
Yes. Subtract the sum of the range from the starting value. For example, if the starting amount is in B2 and deductions are in C2:C5, use =B2-SUM(C2:C5).
Why does my subtraction formula show a negative number?
The amount after the minus sign is greater than the amount before it, or the cell order may be reversed. Check the input values and the direction of the subtraction; a negative result can be a valid shortfall.
Why does Excel show the formula instead of calculating it?
The cell may be formatted as Text, the formula may lack its leading equals sign, or Show Formulas may be turned on. Change the cell format to General and re-enter the formula, and check the formula display setting.
Related
- Data Validation: Definition, Rules, and Examples
- Excel Data Validation Date Picker: Setup and Options
- Excel Data Validation for Dates: Rules and Examples
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Do Excel Merged Cells Need to Be the Same Size to Sort?Yes. When you sort a range in Excel, any merged cells included in that range must have the…
- Nested IF Statements in Excel: Examples, Limits, and TipsNested IF statements in Excel put one IF function inside another, letting a formula choose among several outcomes.…
- Salesforce Row-Level Formula Examples for ReportsSalesforce row-level formulas calculate a value separately for each record in a report; useful examples include discount percentage,…
- Excel Day Countdown: Build a Live Days-Left FormulaWith a deadline date in B2, enter =B2-TODAY() in C2 to show how many calendar days remain. For…
- Excel Filters: How to Sort and Show the Rows You NeedTo filter data in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data…
- Excel TRIM LEN Formula: Count Characters After CleanupTo count the characters in text after removing extra spaces, put the text in A2 and enter =LEN(TRIM(A2))…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.