What Is the Subtraction Function in Excel? | The Minus Sign

Excel has no dedicated SUBTRACT function. All subtraction in Excel is performed using the minus sign (-) as an arithmetic operator.

You open Excel, need to subtract a couple of numbers, and your first instinct is to hunt for a function called SUBTRACT. Makes sense — there’s a SUM function, so why not a SUBTRACT one? The answer is that Microsoft chose a different approach entirely.

Excel treats subtraction the same way basic arithmetic does: with a minus sign. So the real question isn’t which function to use — it’s how to write the formula. This guide covers the core syntax, common use cases, and several workarounds you’ll run into once you move past simple cell-to-cell subtraction.

The Basic Syntax You Need To Know

Every subtraction in Excel follows the same pattern: an equals sign, a number or cell reference, the minus sign, and another number or cell reference. The formula =10-5 returns 5. The formula =A1-A2 subtracts whatever is in A2 from whatever is in A1.

That’s it at its simplest. The structure doesn’t change whether you’re working with whole numbers, decimals, dates, or times — the minus operator handles all of them.

One detail that trips up new users: you don’t wrap the operation in parentheses or a function name. Just the equals sign and the arithmetic. The minus sign does all the work that a dedicated function would otherwise need to do.

The Two Numbers Have Names

In a subtraction like =A1-A2, the number being subtracted (A2) is technically called the subtrahend, and the number you subtract from (A1) is the minuend. You don’t need to remember these terms to use Excel, but they show up in documentation and troubleshooting guides occasionally.

Why People Expect a SUBTRACT Function

It’s a fair assumption. Excel has functions for addition (SUM), multiplication (PRODUCT), and division (QUOTIENT). So when people ask “What Is the Subtraction Function in Excel,” they’re usually surprised to learn there isn’t one. The logic Microsoft settled on keeps formulas simpler and avoids redundant functions.

Another reason the misconception sticks: the minus sign looks less official than a function call. Typing =SUM(A1:A10) feels like you’re telling Excel to do something formal. Typing =A1-A2 feels like you’re just writing a note. But both are equally valid instructions.

Once you accept the minus sign as the primary tool, the whole system opens up. Here’s what you can do with it beyond simple cell subtraction:

• Subtract multiple cells: Use =A1-B1-C1-D1 to subtract several values from a starting cell in a single formula.
• Subtract a range with SUM: The formula =A1-SUM(B1:B5) subtracts the total of B1 through B5 from A1 — useful for budgets or inventory checks.
• Subtract across columns: Write =A1-B1-C1 in the first cell, then drag the fill handle across the row to apply the same pattern to other columns.
• Subtract an entire column from one cell: Use an absolute reference like =A1-$B$1. Copy it down the column, and every cell in column A subtracts the same fixed value from B1.
• Subtract dates and times: =B2-A2 returns the number of days between two dates. For times, the same formula works but may need formatting as “Time” to display correctly.

All of these rely on the same minus sign. There’s no separate function for any of them. The flexibility comes from combining the minus operator with other functions, which is where things get interesting.

Subtraction Inside Other Functions

The minus sign works anywhere an arithmetic operator is valid, including inside other formulas. For example, =SUM(A1:A10)-B1 first adds the range A1 through A10, then subtracts B1. You get the efficiency of SUM with a subtraction attached.

Another common pattern uses MAX to prevent negative results. The formula =MAX(0, A1-B1) subtracts B1 from A1 but returns zero instead of a negative number — useful for expense tracking where running balances should never go below zero.

One detail worth noting: subtracting in Excel is mathematically identical to adding a negative number. The formula =8-2 produces the same result as =8+(-2). Byui’s academic guide explains this concept in its lesson on adding a negative number, which helps when you’re debugging formulas that aren’t producing the expected result.

These patterns cover roughly 90% of subtraction scenarios you’ll encounter in day-to-day spreadsheet work. The remaining cases — like subtracting text or matrices — require workarounds using other functions, which are covered in the next section.

Advanced Workarounds for Unusual Cases

Sometimes you need to subtract things that aren’t plain numbers. Microsoft’s documentation confirms there’s no SUBTRACT function, but that doesn’t mean you’re stuck. Here are a few less common scenarios and how to handle them.

Subtracting text: You can’t use the minus sign on text strings. To remove a substring, use the SUBSTITUTE function: =SUBSTITUTE(A1, "old", "") removes every occurrence of “old” from the text in A1. This isn’t a true subtraction, but it’s the closest Excel offers.

Subtracting matrices: Select the output range (same size as the matrices), type =A1:C3 - E1:G3, and press Ctrl+Shift+Enter to create an array formula. Each cell in the output gets the corresponding difference between the two input matrices.

Running Subtraction Balance

For a running checkbook-style balance, start with =B2-C2 in the first row. In subsequent rows, use =D2-B3+C3 — this takes the previous balance, subtracts new debits, and adds new credits. Drag the fill handle down to copy the pattern to every row.

An alternative for percentage subtraction: =A1-(A1*20%) subtracts 20% of A1 from A1. This formula is functionally identical to =A1*(1-20%) but some users find the expanded version easier to read when auditing their work.

The Bottom Line

Excel’s subtraction function is the minus sign — no dedicated function exists, and none is needed. For basic work, =A1-B1 does everything a SUBTRACT function would. For advanced scenarios, combine the minus operator with SUM, MAX, SUBSTITUTE, or array formulas to handle ranges, dates, text, and matrices. The syntax is consistent, the patterns are learnable, and the result is a spreadsheet that calculates exactly what you expect.

If you’re building a complex workbook and need help troubleshooting a subtraction formula that isn’t behaving, Microsoft’s official support page can help you sort through common pitfalls like absolute references, cell formatting, and nested functions — all free and updated for the latest Excel version as of 2025.