How To Subtract One Cell From Another In Excel | Do It Right

Subtracting cells in Excel is simple once the pattern clicks. You pick the cell with the starting value, type a minus sign, then pick the cell you want to take away. Excel does the rest.

That sounds small, yet this one formula sits behind budget sheets, stock logs, payroll trackers, grade books, and month-to-month reports. Get it right once, and you can drag it through a whole column in seconds. Get one tiny part wrong, and the sheet starts spitting out odd totals.

This page walks through the clean way to subtract one cell from another, when to lock a reference with a dollar sign, and what to do when dates, times, or copied formulas stop behaving.

What Cell Subtraction In Excel Actually Does

Excel treats subtraction as a basic math operation. Every formula starts with an equals sign. After that, you can click cells instead of typing raw numbers, which keeps the sheet flexible. When a value changes in one cell, the result updates on its own.

The basic pattern is short:

• Click the cell where you want the answer.
• Type =
• Click the first cell.
• Type -
• Click the second cell.
• Press Enter.

If A2 has 125 and B2 has 40, the formula =A2-B2 returns 85. That is the whole move. Microsoft’s page on subtracting numbers in Excel uses the same minus-sign method.

How To Subtract One Cell From Another In Excel Across A Column

This is where most people save time. Say column A holds planned spending and column B holds actual spending. You want the difference in column C. Write the formula once, then fill it down.

Set Up The First Formula

Click C2 and enter =A2-B2. Press Enter. If the answer looks right, click C2 again. Move your cursor to the tiny square at the lower-right corner of the cell, then drag down. Excel copies the pattern row by row.

So C3 becomes =A3-B3, C4 becomes =A4-B4, and so on. That shifting behavior is normal. Excel calls these relative references. Microsoft’s page on creating a simple formula shows the same structure: equal sign first, then cell references and operators.

Check The Sign Of The Result

Order matters. =A2-B2 is not the same as =B2-A2. If the second value is larger, Excel returns a negative number. That is often correct, not a mistake.

A few common uses:

• Budget gap: planned amount minus actual amount
• Inventory left: stock in minus stock sold
• Score change: new score minus old score
• Price drop: old price minus sale price

If you want the result to stay positive no matter what, wrap the formula in ABS, like =ABS(A2-B2).

Use This Cheat Sheet For The Most Common Subtraction Jobs

Why Copied Formulas Change, And When They Should Not

Most subtraction formulas work because Excel shifts references as the formula moves. That is handy when each row has its own pair of numbers. Yet sometimes you need one part of the formula to stay glued to a single cell.

Say A2:A20 holds item prices, and B1 holds a flat discount. If you write =A2-B1 in C2 and drag down, the next row turns into =A3-B2. That is wrong if the discount always lives in B1.

Use Dollar Signs To Lock The Reference

Write the formula as =A2-$B$1. Now the A2 part shifts as the formula moves, but B1 stays fixed. That dollar-sign rule is the fix for a huge share of broken Excel formulas. Microsoft breaks this down in its page on relative, absolute, and mixed references.

There are three patterns worth knowing:

• A1 = both row and column can change
• $A$1 = row and column stay fixed
• A$1 or $A1 = one part stays fixed

If you are copying subtraction formulas and the answers drift off in odd ways, this is the first thing to check.

Subtract Dates, Times, And Percentages Without The Mess

Excel handles more than plain numbers. The same minus sign works with dates and times too, though formatting can trip people up.

Subtracting Dates

If A2 is 3/1/2026 and B2 is 3/10/2026, =B2-A2 returns 9. Excel stores dates as serial numbers behind the scenes, so subtraction gives you the number of days between them.

If the result looks like a date instead of a day count, change the result cell format to General or Number.

Subtracting Times

If A2 holds 8:30 AM and B2 holds 5:15 PM, =B2-A2 returns the hours worked. If the answer shows a strange decimal or clock value, switch the cell format to Time, or use a custom format like [h]:mm when totals run past 24 hours.

Subtracting A Percentage

People often want to reduce a value by a rate, not subtract one percentage cell from another. If A2 is 200 and you want to remove 10%, use =A2-(A2*10%). If the percentage sits in B2, use =A2-(A2*B2).

That returns the discounted amount. If you only want the amount removed, use =A2*B2.

Mistakes That Throw Off Excel Subtraction

Most subtraction problems come from a short list of slip-ups, and they are easy to spot once you know where to look.

Numbers Stored As Text

If a cell looks like a number but acts dead, it may be text. You might see a green triangle in the corner. Convert the value to a number, then try the formula again.

Spaces Or Hidden Characters

Data pasted from a site or PDF can carry stray spaces. That can block proper math. Clean the data first if the result does not change or throws an error.

Wrong Cell Order

If the answer is negative and you did not expect that, check whether you flipped the cells. Excel is doing the math you typed, not the math you meant.

Broken References After Copying

If the first answer is right and the rest are wrong, your formula probably needed one locked reference. Add dollar signs where the fixed cell belongs.

A Clean Way To Work Faster With Subtraction Formulas

Once the basic pattern feels easy, the next step is staying tidy. Keep raw data in one set of columns and formula results in another. Label the result column with plain text like Difference, Remaining, or Variance. That makes the sheet easier to scan later.

It also helps to click a result cell and check the formula bar before filling down a large range. One ten-second check can save a lot of cleanup.

If you only need subtraction once, type the formula and move on. If you are building a sheet you will reuse every week or month, use fixed references where needed, test the first few rows, and then copy the formula through the rest of the table. That small habit keeps your numbers steady and your sheet calm.

Send us your feedbackTell us what you thought about this post

Name * Email *

Your comment *

Quick check — what is …? *

Send feedback