When you open a spreadsheet and look for a dedicated subtraction button or formula, you won't find one. Unlike addition, which gives you the SUM function, subtraction relies on a simple minus sign operator. You write formulas by combining cell references with standard arithmetic symbols to find differences, calculate profit margins, or track project timelines.
To subtract two cells in Excel, select the destination cell, type an equals sign, click the first cell, type a minus sign, click the second cell, and press Enter. For example, typing =B2-C2 takes the value in cell C2 away from the value in cell B2. This core mechanic powers everything from single calculations to large dataset models across thousands of rows.
The Basic Subtraction Formula
Every formula in Excel begins with an equals sign. When you want to find the difference between two static numbers or cell values, you construct a direct expression.
If you want to subtract 45 from 120 directly, type =120-45 into any cell and press Enter. Hardcoding numbers works for quick scratchpad math, but spreadsheets derive their real utility from dynamic cell references. If your revenue sits in cell B2 and your expenses sit in cell C2, typing =B2-C2 ensures your output updates automatically whenever your input numbers change.
- Start by clicking the cell where you want your result to appear.
- Type the equals sign (
=) to signal to Excel that a formula is starting. - Click or type the cell reference for your starting value, such as
B2. - Type the minus sign (
-). - Click or type the cell reference for the amount you want to remove, such as
C2. - Press Enter to compute the final value.
Subtracting Multiple Cells and Ranges
Real-world spreadsheets often require taking multiple values away from a single total. You can chain multiple cell references together using consecutive minus signs, or you can use a helper function to streamline long ranges.
When you need to subtract three separate expense cells (C2, D2, and E2) from a starting budget in cell B2, you can write =B2-C2-D2-E2. Excel evaluates this chain from left to right.
However, writing long chains gets messy when you have dozens of columns. You can combine the starting cell with the SUM function to subtract an entire contiguous block of numbers at once. Writing =B2-SUM(C2:E2) adds up all the values in that range first and then subtracts that total from your starting cell. This approach keeps your formulas short, readable, and easy to audit.
Subtracting Across Entire Columns
Calculating differences for a single row is useful, but business models require applying that same logic down an entire table of data. You don't need to type a formula for every individual row.
Suppose column B contains your monthly revenue and column C contains your monthly costs. In cell D2, enter your standard formula: =B2-C2. Once you press Enter, click back on cell D2 and locate the fill handle—the tiny green square at the bottom-right corner of the cell border. Double-click that square or click and drag it down to the bottom of your data range.
Excel automatically adjusts the row numbers for every row as the formula copies down, transforming your initial expression into =B3-C3, =B4-C4, and so on. This row-by-row adjustment saves hours of manual data entry on large datasets.
Locking Cells with Absolute References
Sometimes you need every row in a column to subtract the exact same fixed value. If you want to subtract a flat administrative fee of $50 from every employee's sales total, writing a standard relative formula will cause Excel to shift down into empty cells.
To keep your formula pointing at a single static cell while you drag it down a column, you use absolute references. Placing dollar signs around the column letter and row number, such as -$F$1, locks that reference in place.
If cell F1 holds your $50 fee, your formula in cell B2 becomes =A2-$F$1. When you drag this formula down the column, A2 turns into A3, A4, and A5, but $F$1 remains completely unchanged. You can also press the F4 key on your keyboard while your cursor is touching the cell reference in the formula bar to cycle through absolute reference options automatically.
Subtracting Percentages and Discounts
Calculating price reductions or margin drops requires more than just subtracting a flat integer. If you want to take 15 percent off a retail price, subtracting the number 0.15 directly will ruin your results.
You can calculate percentage subtractions using two standard methods. The first method multiplies the original price by the remaining percentage: =B2*(1-C2), where B2 holds the original price and C2 holds the 15 percent discount. The second method calculates the discount amount first and subtracts it from the base value: =B2-(B2*C2). Both formulas yield identical outputs, but the first version is shorter and easier to scale across complex financial models.
Subtracting Dates and Times
Excel stores dates and times as sequential serial numbers, meaning you can subtract them just like regular integers to track durations, deadlines, or employee shift hours.
If a project starts in cell A2 (entered as 2026-03-01) and finishes in cell B2 (2026-03-15), the formula =B2-A2 returns 14, representing the exact number of elapsed days. If your result displays as a strange date in the year 1900 instead of a clean number, select the cell, right-click, choose format options, and set the cell format to General.
For tracking hours worked during a shift, subtracting a start time from an end time (=B2-A2) calculates total elapsed time. To make sure Excel displays hours correctly when a shift crosses past midnight or exceeds a standard 24-hour block, apply a custom cell format like [h]:mm through the Format Cells dialog menu.
Common Mistakes to Avoid
- Using a non-existent function: Typing
=SUBTRACT(B2, C2)results in a#NAME?error because Excel doesn't recognize that word as a valid function. Always use the minus sign. - Forgetting the equals sign: Typing
B2-C2without the leading=tells Excel to treat your input as plain text rather than an active calculation. - Incorrect percentage syntax: Writing
=B2-15%works for a single static cell, but writing=B2-C2whenC2holds an unformatted integer like15instead of0.15causes massive calculation errors.
Frequently Asked Questions
Why doesn't Excel have a SUBTRACT function?
Excel relies on basic arithmetic operators for fundamental math. Because the minus sign - handles subtraction efficiently across cells, ranges, and negative numbers, a dedicated text function was never added to the core formula library.
How do I handle negative numbers in subtraction?
If your subtraction formula results in a negative value, Excel displays a standard minus sign in front of the number by default. If you need to ensure an output is always positive regardless of which number is larger, wrap your formula inside the absolute value function, written as =ABS(B2-C2).
Can I subtract text strings in Excel?
You cannot subtract text values or names using arithmetic operators. Trying to subtract one text string from another triggers a #VALUE! error. If you need to remove specific characters or substrings from text data, use text manipulation formulas like the SUBSTITUTE function instead.
How do I subtract columns without creating a new formula column?
If you want to subtract one column from another permanently without leaving active formulas behind, copy the subtrahend column, select your destination range, right-click to open Paste Special, select Values under Paste and Subtract under Operation, and click OK.
