How to Subtract in Excel Using a Formula Step by Step

Formulas & functions · Updated November 20, 2026

To subtract in Excel, enter a formula with a minus sign in the cell where you want the answer. With the starting amount in A2 and the amount to subtract in B2, enter =A2-B2 in C2; if A2 contains 25 and B2 contains 7, Excel returns 18. You need only a worksheet and the values you want to calculate. The same method works for whole numbers, decimals, dates, and cell references.

Excel does not have a dedicated subtraction function for ordinary calculations. You use the minus operator between numbers or cell references, and Excel recalculates the result when the referenced values change. The instructions below are for Excel for Microsoft 365 on Windows. Excel for Mac and Excel for the web use the same subtraction formula; some interface details may look different.

What You’ll Need

  • An Excel workbook with the values you want to subtract, or a blank worksheet where you can enter them.
  • A cell for the result. It is usually easiest to put the result in a separate column so that the original values remain unchanged.
  • A basic understanding of which value should be subtracted from which. Order matters: the first value is the amount you start with, and the value after the minus sign is taken away from it.

Step-by-Step

  1. Enter the values in separate cells. For example, put an original balance of 25 in A2 and an expense of 7 in B2. Add labels such as Original amount, Expense, and Remaining amount in row 1 if that will make the worksheet easier to understand. Keeping the two inputs separate makes it clear what each number represents and lets Excel update the answer when either value changes.

  2. Select the cell for the answer. Click C2, or another empty cell beside the inputs. Do not type the answer over A2 or B2 if you still need those original values. A result column is especially useful when you have many rows to calculate, because each row can use the same pattern.

  3. Type the formula, starting with an equals sign. With the starting amount in A2, the amount being subtracted in B2, and the answer intended for C2, enter =A2-B2 in C2. The equals sign tells Excel to calculate rather than treat the entry as ordinary text. You can type the cell references, or click A2, type the minus sign, and click B2 while entering the formula.

  4. Press Enter and check the result. With A2 containing 25 and B2 containing 7, =A2-B2 returns 18 in C2. Excel typically moves the selection down one cell after you press Enter. To change the result, edit either input cell; the formula recalculates automatically as long as calculation is set to Automatic.

  5. Use a number directly when the amount is fixed. If A2 contains the starting amount and you always need to take away 5, enter =A2-5 in the result cell. For example, if A2 is 25, the answer is 20. A typed number can be convenient for a one-off calculation, but use a separate input cell instead if you might need to change that amount later or want the sheet to document the assumption.

  6. Copy the calculation down for more rows. If A2:A5 contains starting amounts and B2:B5 contains the corresponding deductions, first enter =A2-B2 in C2. Select C2 and drag the small square at its lower-right corner down through C5. Excel adjusts the relative references for each row, so C3 uses A3 and B3, and so on. You can also copy C2, select C3:C5, and paste. Check a lower row to make sure the references follow the values on that row.

  7. Subtract a total made up of several cells, if needed. With a starting amount of 500 in A2 and individual deductions in B2:B5, put the result in C2 using =A2-SUM(B2:B5). If B2:B5 contains 20, 30, 10, and 40, the deductions total 100 and C2 returns 400. SUM adds the listed cells first; the minus sign then subtracts that total from A2. This is useful for expenses or adjustments recorded on separate rows.

Common Mistakes

Leaving out the equals sign. An entry that begins with a cell reference or number but not an equals sign may be displayed as text instead of calculated. Start a formula with =, then use the minus sign between the values.

Reversing the order. Subtraction is not commutative: taking 7 away from 25 gives 18, while taking 25 away from 7 gives -18. Check that the first reference is the starting amount and the second is what you intend to remove. A negative answer is not necessarily an error; it may mean the deduction is larger than the starting amount.

Using the wrong row when copying. When you copy a formula down, Excel normally changes relative references to match the new row. That is helpful for row-by-row data, but it can produce an unexpected answer if the formula was meant to keep referring to one fixed cell. Check a copied formula against its row inputs before relying on a long column of results.

Typing a value that looks numeric but is text. Text entries, stray spaces, or an apostrophe before a number can stop arithmetic from working as expected and may cause a #VALUE! error. Confirm that the input cells contain numbers rather than labels or text-formatted entries. Also make sure the formula is not being displayed as text because the destination cell is formatted as Text.

Expecting a formula to change the original value. A formula calculates an answer in its own cell; it does not remove the second value from the first input cell. Keep the result in a separate cell unless you deliberately intend to replace the source data.

Tips

Use clear headings and consistent columns. For example, keep starting amounts in one column, deductions in the next, and results in a third. This makes it much easier to see which values the formula uses, spot a misplaced entry, and explain the worksheet to someone else. If your data has headings, keep the formula rows separate from the heading row.

Use cell references instead of typing every value into the formula when the numbers are already in the worksheet. A reference-based formula stays connected to its inputs: if an amount changes, the result updates without your having to rewrite the calculation. For one-time arithmetic, subtracting a typed number may be quicker, but an input cell is more transparent for a calculation you will revisit.

If a formula must keep referring to one fixed starting value while you copy it down, use an absolute reference. With a fixed amount in A2, deductions in B2:B4, and results in C2:C4, enter =$A$2-B2 in C2 and copy it down. The dollar signs lock A2, while B2 changes to B3 and B4. For a normal row-by-row calculation where both inputs change on each row, leave both references relative.

Format the result to suit the data. Use a number or currency format for amounts, and choose enough decimal places if the inputs include cents or other fractions. Formatting changes how a value appears, not the underlying subtraction. If you see rounded numbers, check the cell’s displayed decimal places before assuming Excel has lost precision.

For dates, subtraction can tell you the number of days between two dates. With the earlier date in A2 and the later date in B2, enter =B2-A2 in C2; if A2 is January 3 and B2 is January 10 of the same year, the result is 7 days. Format C2 as General or Number if Excel displays the result as a date. For times, subtraction can return elapsed time, but when the end time is earlier because a task passed midnight, the calculation needs extra handling.

Troubleshooting

The cell shows the formula instead of the answer. Check that the destination cell is not formatted as Text. Set it to General using Home > Number Format, then edit the cell and press Enter so Excel processes the entry again. Also check whether Show Formulas is turned on; the Formulas tab includes the Show Formulas control. If formulas appear across the whole worksheet, that setting is a likely cause.

You see #VALUE!. One of the referenced cells may contain text, a label, or a value Excel cannot use in arithmetic. Inspect both input cells, remove unwanted spaces or symbols, and enter the values as numbers. A blank referenced cell is generally treated as zero in simple arithmetic, so also check whether an input was accidentally left empty.

You see ####### instead of a number. This usually means the column is too narrow to display the formatted result, rather than that subtraction failed. Widen the column by dragging its right boundary, or double-click that boundary to fit the contents. If the result is a negative date or time, changing the number format may help reveal what Excel can display.

The result does not update after you change an input. Confirm that the formula refers to the cells you edited and that calculation is set to Automatic. In Excel for Microsoft 365 on Windows, check Formulas > Calculation Options > Automatic. If the formula was pasted as text, re-enter it as a formula. You can also select the result cell and review the formula in the formula bar to check for an incorrect reference.

The copied results look wrong. Compare the formula in the first row with one lower down. For a row-by-row subtraction, the references should move with the row. If one reference must remain fixed, use dollar signs around that cell reference before copying. Check the underlying values as well as the displayed results, because number formatting can hide decimal places.

Frequently Asked Questions

Does Excel have a subtraction function?

For regular subtraction, use the minus operator in a formula rather than a dedicated subtraction function. Start with an equals sign, then put the value you are subtracting after the minus sign. You can use cell references, numbers, or a combination of both.

Can I subtract more than one number?

Yes. Put another minus sign and value in the formula for each additional amount, or use SUM to total a group of deductions and subtract that total from the starting amount. Make sure the formula reflects the order and grouping you intend.

How do I subtract the same amount from every row?

Put the common amount in a cell, refer to it in the first row’s formula, and lock that reference with dollar signs before copying the formula down. Keep the reference to each row’s starting value unlocked so it changes for each row. Alternatively, subtract a typed constant if it is genuinely fixed and does not need to be maintained elsewhere.

Why does my subtraction result show as a negative number?

A negative result means the value being subtracted is larger than the starting value, or the order of the references may be reversed. Check the inputs and their intended roles. If the deduction really exceeds the starting amount, the negative result is mathematically correct and may be useful information.

Can Excel subtract dates?

Yes. Subtracting one valid Excel date from another returns the number of days between them. If the result is displayed as a calendar date, change the result cell’s format to General or Number. Check that both inputs are recognized as dates, not text that merely looks like a date.

Will subtraction work in Excel for Mac or the web?

Yes. The minus operator and cell-reference syntax are the same in Excel for Windows, Mac, and the web. The interface for formatting cells or changing calculation settings can differ slightly, but the formula itself does not need to change.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.