Excel has no SUBTRACT function, but subtraction is still easy once you use the right formula pattern. The minus sign handles numbers and cells, while SUM, Paste Special, and date and time formulas handle bigger jobs.
Start with the basic cell formula when you need a quick answer. Use the later fixes for discounts, balances, elapsed time, bulk changes, and formulas that stop updating.
Start with a basic subtraction formula
The fastest way to subtract in Excel is to type a formula that starts with an equals sign. Select a blank cell, type =50-10-5-3, then press Enter or Return.
For values already in your sheet, put the numbers in two cells, such as C1 and D1. Select the result cell, type =C1-D1, then press Enter or Return.
The minus sign also works in Excel for the web and Excel mobile apps. A formula such as =3-1 subtracts values, while =-1 enters a negative number.
Subtract several numbers at once
When you need one total after several deductions, enter the values you want to subtract as negative numbers and use SUM. For example, =SUM(100,-32,15,-6) starts with 100, subtracts 32, adds 15, and subtracts 6.
The same idea works across cells. If A2 through A4 include positive and negative numbers, type =SUM(A2:A4) in the result cell and press Enter or Return.
AutoSum can do this when the negative numbers are already in the range. Select a cell next to or below the range, choose Home or Formulas, select AutoSum, then press Enter or Return. On Windows, press Alt+=; on Mac, press Shift+Command+T.
If the total is wrong, check that every number meant to be subtracted has a minus sign. For a simple two-cell deduction, use =A1-B1.
Fix subtraction formulas that do not update
The most common cause is manual calculation, which stops formula results from recalculating after source cells change.
In Excel for Windows desktop, open File > Options > Formulas > Calculation options > Workbook Calculation, then choose Automatic.
You can also use the ribbon. Open Formulas > Calculation Options, then choose Automatic.
In Excel for the web, go to Formulas > Calculation Options and choose Automatic. For manual recalculation in the desktop app, use F9, Shift+F9, Ctrl+Alt+F9, or Ctrl+Shift+Alt+F9.
Subtract a percentage from a number
Discounts, price cuts, and percentage reductions use multiplication. Instead of subtracting the percent by itself, multiply the number by 1 minus the percent.
To subtract 15% from a value in A2, enter =A2*(1-15%) in the result cell. Excel returns the remaining 85% of the original value.
Fill the formula down when the same percentage applies to more rows. Change the cell reference or percentage when each row uses a different value.
Change existing cells with Paste Special Subtract
This fixes bulk updates when existing numbers need the same copied value or range subtracted from them.
Copy the value or range you want to subtract.
Select the destination cell or range that should be reduced.
Open Home, select the Paste clipboard icon, then choose Paste Special. In Excel for Windows desktop, press Ctrl+Alt+V to open Paste Special.
Choose a paste option such as Values when the copied content should be pasted as values.
Under Operation, select Subtract, then choose OK.
Subtract dates in Excel
For days, use ordinary addition or subtraction with the date cell. If A1 contains a date, =A1-15 returns a date 15 days earlier.
For repeated day calculations, put starting dates in column A and the number of days in column B. Use negative numbers for days you want to subtract, enter =A2+B2 in C2, then copy it down.
For months, use EDATE. Put the start date in A2, put a negative month value such as -1 in B2, then enter =EDATE(A2,B2). A direct formula such as =EDATE(A1,-5) subtracts five months.
For years, use DATE with YEAR, MONTH, and DAY. With a start date in A2 and the years to subtract entered as a negative number in B2, use =DATE(YEAR(A2)+B2,MONTH(A2),DAY(A2)).
If the result goes the wrong direction, confirm that the value being subtracted is negative for days, months, or years. For workday counts that exclude weekends, use NETWORKDAYS.INTL.
Subtract times and calculate elapsed hours
Enter the start time in B2, including a space and a or p for AM or PM.
Enter the end time in C2.
In D2, type =C2-B2 and press Enter.
Open Format Cells, choose Custom, select the Type list, enter h:mm, then choose OK.
Drag the formula down when the next rows use the same layout.
For time spans longer than 24 hours, format the start and end cells with a custom date-time format such as m/d/yyyy h:mm AM/PM, enter both date-times, then calculate hours with =(B2-B1)*24.
Excel for the web can add and subtract time spans longer than 24 hours, but custom number formatting is limited.
Build a running balance
This fixes checkbook-style sheets where each row subtracts withdrawals and carries the balance forward.
Create columns for deposits, withdrawals, and balance.
In the first balance row, enter =SUM(A2-B2).
In the next balance row, enter =SUM(C2,A3-B3).
Click outside the cell so Excel calculates the result.
When you add new rows, select the last balance cell and double-click the fill handle to extend the formula.
Use Copilot for a subtraction formula
Copilot in Excel can create a subtraction or difference formula for eligible Microsoft 365 users. Open the workbook, select the Copilot icon in the lower-right corner of Excel, and ask for a clear calculation such as “Calculate the difference between the values in cell D1 and E1.”
Copilot can also make workbook edits from a natural-language request. In edit mode, ask it to create a new column that subtracts one column from another, then review the plan and verify the workbook changes.
Work or school access depends on Microsoft 365 licensing and account configuration. If the Copilot icon is missing, use the formula methods above or contact the person who manages Microsoft 365 for your organization.
Frequently Asked Questions
Is there a SUBTRACT function in Excel?
No. Excel uses the minus sign in formulas, such as =A1-B1. For several deductions, enter the deductions as negative numbers and add the range with SUM.
How do I subtract one column from another in Excel?
In the first result cell, enter a formula such as =A2-B2, then fill the formula down so each row subtracts the matching cells.
How do I subtract 10 percent in Excel?
Use the number multiplied by 1 minus the percentage. For a value in A2, enter =A2*(1-10%).
Why is my Excel subtraction result not changing?
Usually Excel is set to manual calculation. Change Calculation Options to Automatic, or recalculate manually with the desktop shortcuts. If it is already Automatic, check that the formula cell is not formatted as Text and that the formula starts with an equals sign.
