Minus Formula in Excel — Complete Guide (2026)

Minus Formula in Excel — Complete Guide (2026)

Short answer up front: Excel doesn't have a MINUS function. There's no =MINUS(A1, B1). Never has been. The minus formula in Excel is just the minus sign — the same hyphen-looking key on your number row — used as an arithmetic operator inside a regular formula.

Type =A1-B1 in any cell. Press Enter. That's the whole formula. Excel treats the dash as a binary subtraction operator the moment a formula starts with an equals sign. If you try =MINUS(A1,B1), you'll get a #NAME? error because Excel reads MINUS as an undefined function name. Google Sheets has a MINUS() function — Microsoft Excel does not, and the two products aren't fully interchangeable on this.

So the question shifts. The interesting question isn't "what's the function called" — it's "how do I subtract the thing I actually need to subtract." Two cells? One cell from many? A whole column from another? A constant from a list? A range total from a starting balance? Dates? Times? Negative results forced positive? Each one uses the minus operator, but the wrapper around it changes.

This guide walks every common subtraction pattern with copy-ready formulas. Most are one line. A few use helper functions like SUM, SUMPRODUCT, ABS, or IF — and yes, you can chain those with the minus operator without breaking anything. If you've ever wondered why your excel subtraction formula returned #VALUE! or why your date result came back as 1/2/1900 instead of "30 days," the fixes are below.

One more thing before the examples: order of operations matters when you subtract more than two things. Excel evaluates =10-3-2 left to right because subtraction has the same precedence and associates leftward — you get 5, not 9. Parentheses override this. Keep that in mind when chaining.

Basic Cell Subtraction: =A1-B1

The simplest minus formula in Excel takes two cell references and returns the difference. Click an empty cell. Type =A1-B1. Hit Enter. Done.

That's it. There's nothing else to learn for the basic case. The cell shows the result; the formula bar shows =A1-B1. Change A1 or B1 and the result updates instantly because formulas are live, not static.

Real example

Say A2 has 250 (revenue) and B2 has 175 (cost). In C2, type =A2-B2. C2 shows 75. Now copy that formula down for 50 more rows — every row of C calculates revenue minus cost for that row automatically. That's the power of cell references in excel doing what they should.

Subtracting Whole Columns (Drag-Fill Pattern)

You rarely subtract just one row. The standard workflow: write the formula once, then fill it down so every row in column C subtracts the matching cells in A and B.

Three ways to fill down — pick whichever fits your hands:

• Mouse drag. Click the cell with your formula. Look at the bottom-right corner — there's a small green square called the fill handle. Click and drag it down to the last row.
• Double-click the fill handle. Faster. If column A or B has data adjacent, Excel auto-fills the formula down to match. No dragging.
• Keyboard. Select the range first (C2 down to wherever), type the formula in C2, then press Ctrl + Enter. Excel fills the whole selection at once.

Relative references adjust as you fill. =A2-B2 becomes =A3-B3 in row 3, =A4-B4 in row 4, and so on. That's why drag-fill works — Excel rewrites the row numbers for you.

When you don't want them to adjust

Lock a reference with dollar signs. Say B1 holds a fixed tax rate you want every row to subtract. Write =A2-$B$1. The $ on B1 means "don't change this when filling." Drag down and every row still subtracts from B1, not B2, B3, B4. F4 is the keyboard shortcut to add and cycle dollar signs.

Subtracting Multiple Cells: Order of Operations

Excel chains subtractions left to right. =A1-B1-C1 evaluates as (A1-B1)-C1, not A1-(B1-C1). Forget that and your payroll calculations will look right until someone audits them.

Quick test. Type =10-5-2 in any cell. Result: 3. That's (10-5)-2 = 5-2 = 3. If Excel grouped right-to-left, you'd get 10-(5-2) = 10-3 = 7. It doesn't.

This matters for net pay, running balances, and anything where you subtract several deductions from one starting value. =Gross-Federal-State-FICA-Health-401k works perfectly because the leftward grouping matches how you'd compute it by hand.

When you need a different order

Wrap with parentheses. =A1-(B1+C1) first adds B1 and C1, then subtracts the sum from A1. Mathematically identical to =A1-B1-C1, but the parentheses version is easier to read when you have a long chain.

You can also mix operators. =A1+B1-C1*2 follows standard math precedence — multiplication first (C1*2), then left-to-right addition and subtraction. So that's A1 + B1 - (C1*2). If you want addition before multiplication, you need =(A1+B1-C1)*2. Always sanity-check with a calculator on the first row before filling down.

Subtract a Range Using SUM

Excel can't subtract a range directly. =A1-B1:B10 doesn't return what you expect — depending on your Excel version, it returns the value in B at the same row as the formula, or a #VALUE! error. The fix is to wrap the range in SUM first.

=A1-SUM(B1:B10) takes the value in A1 and subtracts the total of B1 through B10. This is the canonical pattern for "starting balance minus all expenses," "budget minus all line items," or "forecast minus actual sales across a period." You'd also use it for inventory: =Opening-SUM(Sales!B:B) gives current stock after every sale logged in the Sales tab.

SUM ignores text cells and empty cells, so partial data won't crash the formula. It does count zero values, which is usually what you want. If you need to ignore zeros, switch to sumif function in excel with a criteria like "<>0".

Subtract one range from another

Same trick on both sides: =SUM(A1:A10)-SUM(B1:B10). This is the standard "total income minus total expenses" formula every household budget uses. Drag it nowhere — it lives in one summary cell.

SUMPRODUCT for Array Subtraction

Sometimes you need to subtract two columns row-by-row and sum the result — without first writing the row-by-row formula in a helper column. SUMPRODUCT handles this in one cell.

Say you have unit sales in B2:B100 and returns in C2:C100. You want total net units sold. The cell-by-cell way is to write =B2-C2 in D2, fill down, then sum D2:D100. Three steps. The one-step way: =SUMPRODUCT(B2:B100-C2:C100). Excel does the row-by-row subtraction in memory, then sums the results.

Why SUMPRODUCT instead of SUM? Because =SUM(B2:B100-C2:C100) only works as an array formula (entered with Ctrl+Shift+Enter in older Excel; works as a regular formula in Excel 365 with dynamic arrays). SUMPRODUCT bypasses the array-entry requirement and works in every Excel version from 2003 forward.

Conditional SUMPRODUCT subtraction

SUMPRODUCT also handles logic. To subtract C from B only for rows where category in column A equals "Retail": =SUMPRODUCT((A2:A100="Retail")*(B2:B100-C2:C100)). The first parenthesized expression returns TRUE/FALSE for each row (which Excel treats as 1/0), and multiplying it by the subtraction zeroes out rows that don't match.

For more on array math, see excel sumproduct. Also useful when you're computing weighted differences.

Subtracting Dates: How Many Days Between?

Excel stores dates as serial numbers — January 1, 1900 is day 1, and every day since increments by 1. That means subtracting two dates returns the number of days between them, automatically.

If A1 has 12/15/2025 and B1 has 11/01/2025, =A1-B1 returns 44 — the days between. No DATEDIF, no DAYS function needed for the basic case. The minus operator handles it.

The catch — and it trips up half the people who try this for the first time — is that Excel inherits the format of the cells you reference. So your result cell might display "2/13/1900" instead of "44." That's because the cell is formatted as Date and 44 is the serial number for February 13, 1900. The math is right; the display is wrong.

Fix the date-format gotcha

Select the result cell. Press Ctrl + 1 to open Format Cells. Choose Number (with 0 decimal places). Click OK. The cell now shows 44. The underlying value never changed — only how it's displayed. For workflows where you want days, hours, or business days specifically, switch to datedif excel with the appropriate unit code.

If you only want business days (skip weekends), use =NETWORKDAYS(B1, A1) instead of plain subtraction. Add a holiday list as the third argument to exclude those too.

Subtracting Times: Get Hours, Minutes, or Seconds

Times in Excel are stored as fractions of a day. 6:00 AM is 0.25 (a quarter of 24 hours). Noon is 0.5. 6:00 PM is 0.75. Midnight is 0 or 1. Subtracting times returns the fraction of a day between them.

If A1 is 5:00 PM (clock-out) and B1 is 9:00 AM (clock-in), =A1-B1 returns 0.333… — eight hours expressed as a fraction. Format the result cell as hh:mm:ss and you'll see 08:00:00. That's it. Time math without any helper function.

Format the result properly

Select the cell, press Ctrl + 1, pick Custom, and type [h]:mm in the type box. The square brackets matter — they tell Excel to keep counting past 24 hours instead of rolling over. Without brackets, 25 hours displays as 01:00 (rolled over a day). With [h]:mm, you see 25:00.

Crossing midnight

If clock-in is 10:00 PM and clock-out is 6:00 AM the next morning, plain subtraction gives you negative time — which Excel displays as ######. Fix it with =MOD(A1-B1, 1). The MOD function wraps negative results into positive ones within the [0,1) day range. Format the result as [h]:mm and you'll see 08:00.

For hours as a decimal number — useful for timesheets that pay by the hour — multiply the subtraction by 24: =(A1-B1)*24. Format the cell as Number with one decimal. 7.5 hours, 8.25 hours, that's what you'll see. See convert excel time to decimal hours for the full pattern with overtime rules.

ABS for Absolute Value, IF for Conditional Subtraction

By default, subtraction returns a signed number. =5-10 returns -5. Sometimes you want the magnitude only — how far apart two numbers are, regardless of which is larger. That's the ABS function.

=ABS(A1-B1) always returns a non-negative number. If A1 is 5 and B1 is 10, the result is 5. If A1 is 10 and B1 is 5, also 5. Variance reports, error magnitude, distance calculations — ABS keeps the sign issue out of your way. For more on absolute value in excel, the underlying function handles negatives across many contexts.

Conditional subtraction with IF

Sometimes you only want to subtract when a condition is met. Classic example: discount applies only if the order exceeds a threshold. =IF(A1>100, A1-10, A1) returns A1 minus 10 if A1 is over 100, otherwise just A1.

Another common pattern is "prevent negative results." If you're calculating remaining inventory and you'd rather show 0 than a negative number, use =MAX(A1-B1, 0). The MAX function returns whichever is larger — the subtraction result or zero — so any negative outcome gets clamped. You can do the same thing with IF: =IF(A1>B1, A1-B1, 0). Both work; MAX is shorter.

If you want to subtract only matching rows, use SUMIF: =SUMIF(criteria_range, criteria, sum_range) totals only the rows that match, then subtract that total from your starting value. See the excel sumif function reference for criteria syntax.

Common Subtraction Errors and How to Fix Them

Most minus formula failures fall into three buckets. Knowing which bucket helps you fix in 10 seconds.

#VALUE! when subtracting text from a number

If one of the cells you're subtracting contains text — even text that looks like a number, like "123" with a leading apostrophe — Excel returns #VALUE!. Common cause: data copied from a PDF or web page often arrives as text.

Fix: convert to number. Easiest way — select the bad column, click Data → Text to Columns → Finish. Excel parses every cell as a number. Or use =VALUE(A1)-B1 to force conversion inline. Or multiply by 1: =A1*1-B1. Any of these snap the text back to numeric.

Result shows as a date when you wanted a number

When you subtract two dates, Excel formats the result cell as Date — inheriting from the source. So 44 days displays as 2/13/1900. The data is fine; only the display is wrong.

Fix: select the cell, press Ctrl + 1, choose Number, click OK. Or right-click the cell, pick Format Cells, and choose General or Number. Takes three seconds and it'll never come back.

Time subtraction shows ###### or a negative time

Times that cross midnight produce negative results when subtracted directly. Excel can't display negative times in default formatting — it shows ###### instead.

Fix: wrap in MOD. =MOD(EndTime-StartTime, 1) handles the day-rollover automatically. Apply this anywhere a shift crosses midnight, like overnight nursing schedules or international call logs.

Formula doesn't update when source cells change

Less common but maddening when it happens. If your minus formula returns the same answer no matter what you change in the source cells, calculation mode is set to Manual.

Fix: Formulas → Calculation Options → Automatic. Or press F9 to force a one-time recalc. For more diagnostics, see excel formula not calculating — covers all 10 reasons formulas stop updating.

The minus operator in front of a cell (negation)

One quirk worth knowing. A minus sign before a single cell reference negates the value: =-A1 returns the opposite sign of whatever's in A1. Useful for flipping signs in financial models where expenses are stored as positive and need to display as negative in summaries. Combine with SUM: =-SUM(B2:B10) sums then flips the sign.