To subtract in Microsoft Excel, enter a formula using the minus sign: with the starting value in A2 and the amount to subtract in B2, type =A2-B2 in another cell and press Enter. Excel calculates the difference and updates it when either input changes. You will need a workbook with the values you want to subtract; no special add-in or subtraction function is required.
What You’ll Need
- Microsoft Excel for Microsoft 365 on Windows, or access to Excel for Mac or the web. The basic subtraction steps work in all three.
- A worksheet containing the numbers, dates, or cell values you want to compare.
- An empty cell for the answer. If you want to keep the result for later calculations, use a formula that refers to the input cells rather than typing a fixed answer.
Step-by-Step
- Enter the values in the worksheet. Put the starting value in one cell and the value to subtract in another. For example, enter 125 in A2 and 40 in B2. Adding labels such as Starting amount and Deduction in A1 and B1 makes a larger worksheet easier to understand, but labels are optional. Keep the values in separate cells if you expect them to change; a formula can then recalculate automatically.
- Select the cell for the answer. Click an empty cell where you want Excel to show the result, such as C2. The answer can be on the same row as the inputs or somewhere else in the worksheet. Select the cell itself, not its label, so the result does not overwrite your source data.
- Type a formula beginning with an equals sign. With the starting value in A2 and the amount to subtract in B2, enter
=A2-B2in C2. Excel formulas begin with an equals sign, and the minus sign tells Excel to subtract the value on its right from the value on its left. Do not put spaces or words between the cell references and operator unless you are entering a text label elsewhere. - Press Enter and check the result. In this example, A2 contains 125 and B2 contains 40, so
=A2-B2returns 85 in C2. Excel typically moves the selection to the next cell after you press Enter. If the result is not what you expected, check the order of the references and the values in the input cells. - Subtract more than one value when needed. Excel performs subtraction from left to right. With a starting value in A2, and the amounts to subtract in B2 and C2, enter
=A2-B2-C2in D2. If A2 is 125, B2 is 40, and C2 is 15, the answer is 70. You can continue adding minus signs and cell references for further values. Keep the formula readable, especially if you are subtracting a long list of amounts. - Subtract a total from a starting value. If several deductions are in B2 through B4, you can total them inside a formula. With the starting amount in A2 and the deductions in B2:B4, enter
=A2-SUM(B2:B4)in C2. If A2 is 125 and the three deductions are 10, 15, and 20, the result is 80. This approach is useful when you want to subtract a group of values without writing each reference separately. - Use numbers directly for a quick calculation. You can enter numbers in a formula rather than referencing cells. Type
=125-40in an empty cell and press Enter to get 85. This is convenient for a one-off calculation, but cell references are usually better for a worksheet you will update. A formula with fixed numbers will not change when you edit a separate input cell. - Copy the formula down a column if the same calculation repeats. With starting values in A2:A10 and amounts to subtract in B2:B10, enter
=A2-B2in C2. Select C2, point to the small square at the lower-right corner of the selected cell, and drag it down to C10. Excel adjusts the row references for each result: the next row uses A3 and B3, for example. You can also copy C2, select C3:C10, and paste. Check a few copied results to confirm they follow the intended rows. - Format the result appropriately. If a result appears with too many decimal places or as a plain number instead of currency, select the result cell or cells and use the Number group on the Home tab to choose a suitable number format. For a financial worksheet, apply a currency format when appropriate; formatting changes how a value looks, not the arithmetic in the formula. You can use the Increase Decimal or Decrease Decimal buttons on the Home tab when you need to show more or fewer decimal places.
Common Mistakes
Reversing the order. Subtraction is not commutative: subtracting B2 from A2 does not usually give the same result as subtracting A2 from B2. With the starting amount in A2 and the deduction in B2, =A2-B2 subtracts the deduction from the starting amount. If you reverse the references, the answer may be negative. Decide which value is the starting value before writing the formula.
Leaving out the equals sign or using the wrong operator. A calculation entered without an equals sign may be treated as text or a label rather than a formula. Use the minus sign (-), not a dash copied from a sentence, and do not use a plus sign when you mean to subtract. Excel does not provide a standard SUBTRACT function; ordinary subtraction uses the minus operator.
Typing values that look like numbers but are stored as text. Values imported from another file, preceded by an apostrophe, or containing unexpected spaces may be stored as text. A reference to text in a subtraction calculation can return #VALUE! or behave unexpectedly. Check the cell alignment and warning icon, and use a reliable conversion method if the source data is text. Do not remove punctuation or convert values until you understand whether it represents decimal or thousands separators.
Overwriting an input cell. If you enter the formula in the same cell as one of the values it uses, you can lose the original value or create a circular reference. Put the answer in a separate cell. Keep source values intact when you may need to audit or revise the calculation.
Assuming formatting changes the stored value. A cell displayed as 10.00 may contain a more precise value, such as 10.004. The subtraction uses the stored values, not just the digits currently displayed. Increase the displayed decimal places to inspect the values before concluding that the result is wrong.
Tips
Use clear headings and place related inputs together. A small table with labels, amounts, and a result column is easier to review than a collection of unrelated numbers. If the same operation will be repeated for many records, use one formula in the first result row and fill it down rather than typing each calculation independently. This reduces inconsistent references.
For reusable calculations, keep the formula linked to input cells. When you change an input, Excel recalculates formulas automatically under the usual calculation setting. If the answer does not update, check Formulas > Calculation Options and confirm that Automatic is selected. In a large workbook, calculation may take a moment, but do not replace a live formula with a typed result unless you intentionally want a fixed value.
When subtracting a list of deductions, a total can make the formula easier to maintain. With an initial amount in A2 and a set of deductions in B2:B10, enter =A2-SUM(B2:B10) in C2. If A2 is 500 and the deductions total 135, the result is 365. The SUM function adds the range first, and the minus operator subtracts that total from A2. Confirm that the selected range includes exactly the intended deductions.
Subtraction also works with dates because Excel stores dates as serial numbers. With an earlier date in A2 and a later date in B2, enter =B2-A2 in C2 to calculate the number of days between them. For example, if A2 is 1-Jan-2026 and B2 is 11-Jan-2026, the result is 10 days. Format C2 as General or Number if Excel displays it as a date. This basic calculation counts elapsed days; it does not automatically exclude weekends or holidays.
For a percentage decrease, subtract the new value from the old value to get the amount of the decrease, then divide by the old value if you need the decrease as a proportion. With the old value in A2 and the new value in B2, enter =(A2-B2)/A2 in C2. If A2 is 100 and B2 is 80, the result is 0.2, or 20% when C2 is formatted as Percentage. This example is a spreadsheet calculation, not financial or tax advice; check actual terms with a lender or qualified professional when making money decisions.
On Windows, press Enter to commit a formula. F2 edits the active cell, which is useful for correcting a reference without retyping the whole formula. On Mac, Return commits the entry, and Control+U edits the active cell in Excel for Mac; keyboard settings can affect shortcuts. Excel for the web uses the same minus-sign formulas, though some shortcuts can depend on the browser and operating system. The ribbon steps above are for Excel for Microsoft 365 on Windows; on Mac and the web, the equivalent number-format controls are also available from the Home tab.
Troubleshooting
The cell shows the formula instead of the answer. First, check whether Show Formulas is enabled on the Formulas tab. Turn it off if formulas are being displayed throughout the sheet. If only one cell is affected, it may be formatted as Text. Change its number format to General, then re-enter the formula: select the cell, press F2, and press Enter on Windows. On Mac, edit the cell and press Return. Merely changing the format may not convert a formula already stored as text.
The result is #VALUE!. One of the referenced cells may contain text that Excel cannot use as a number. Inspect each input, including cells that appear blank but may contain spaces or imported text. Re-enter the value as a number or convert the source data carefully, then check the result again. If cells contain units typed directly into the value, place the numeric amount in one cell and the unit in a separate label cell.
The result is negative. A negative result is valid when the value being subtracted is larger than the starting value. If that is unexpected, verify that the formula starts with the intended starting amount and that the inputs are in the right cells. For a balance or remaining-amount calculation, ensure you are subtracting deductions from the original amount rather than the other way around.
The answer looks rounded or is displayed as a date. Select the result and use the Home tab’s number-format controls to choose General, Number, or the format that suits the calculation. Increase decimal places if you suspect hidden precision. For a date difference, choose General or Number to display elapsed days rather than a calendar date.
The answer does not change after editing an input. Confirm the formula actually refers to the edited cell, then check Formulas > Calculation Options > Automatic. If the formula was pasted as a value, it will not recalculate; enter a formula in the result cell again. Also check that calculation is not paused while Excel is editing a cell.
Frequently Asked Questions
Is there a SUBTRACT function in Excel?
No. Use the minus operator between values or cell references. With the values in A2 and B2, enter =A2-B2 in another cell. Excel calculates the difference without a dedicated subtraction function.
How do I subtract a number from every value in a column?
Put the values in A2:A10 and the same amount to subtract in B1. With each starting value in column A and the shared amount in B1, enter =A2-$B$1 in C2 and fill it down. The dollar signs keep the reference fixed on B1 while A2 changes to A3, A4, and so on. If you use the formula for several rows, make sure B1 contains a number.
Can I subtract cells on different worksheets?
Yes. In a result cell on one worksheet, enter =Sheet1!A2-Sheet2!B2 to subtract B2 on Sheet2 from A2 on Sheet1. This assumes the worksheet names are Sheet1 and Sheet2. If a sheet name contains spaces, Excel surrounds it with apostrophes; use the formula bar to select the cross-sheet cells and let Excel create the reference.
How do I subtract dates and get a number of days?
Put the earlier date in A2 and the later date in B2, then enter =B2-A2 in C2. A date range of 1-Jan-2026 to 11-Jan-2026 returns 10. Set C2 to General or Number if Excel formats the result as a date.
Can Excel subtract negative numbers?
Yes. A negative number is subtracted according to ordinary arithmetic, so subtracting a negative increases the result. With 10 in A2 and -3 in B2, enter =A2-B2 in C2; the answer is 13. Check the minus sign in the input cell if the result seems counterintuitive.
Why does Excel show zero when the values look different?
The stored values may be equal even if their display formats differ, or the difference may be smaller than the displayed decimal precision. Increase decimal places for both inputs and the result, and inspect the formula references. If you need a particular rounding rule, apply an appropriate rounding formula only after confirming the desired precision.
Related
- How to Redo in Excel With the Correct Keyboard Shortcut
- How to Redo in Microsoft Excel: Shortcuts and Menu
- How to Rank in Excel with RANK.EQ
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Text Right of Character: Formulas and ExamplesTo return the text to the right of a character in Excel, use TEXTAFTER in Microsoft 365 or…
- Insert a Row in Excel With a Formula: Real OptionsA formula cannot insert a physical worksheet row or move existing cells. To show a blank row inside…
- How to Compare Records in Two Excel Sheets with FormulasTo compare records in two Excel sheets, match each row by a shared, unique ID rather than by…
- Calculating r in Excel: Formula and ExamplesTo calculate Pearson’s correlation coefficient, or r, in Excel, use =CORREL(A2:A6,B2:B6) when the paired x values are in…
- Excel Paste Unique Values: Remove Duplicates or Use a FormulaTo paste unique values in Excel, use Data > Advanced to copy distinct records to another location, or…
- IFERROR Function in Excel: Syntax, Examples, and TipsIn Excel, use IFERROR to return a chosen result when a formula produces an error: the syntax is…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.