How To Subtract Two Cells In Excel | Get Clean Formulas

Subtracting two cells in Excel is one of those small skills that saves a lot of clicking later. Once you know the pattern, you can calculate profit, find score gaps, track stock levels, measure time differences, or compare budgeted and actual numbers in seconds.

The core move is simple: click the result cell, type an equals sign, click the first cell, type a minus sign, click the second cell, and press Enter. Excel does the rest. If either value changes, the answer updates on its own.

That sounds easy, and it is. The part that trips people up is everything around it: subtracting in the right order, copying the formula without breaking references, and knowing what to do when the result looks wrong. This article walks through the clean way to do it, then shows where people usually get stuck.

How To Subtract Two Cells In Excel On A Worksheet

Let’s start with the fastest method. Say cell B2 has your starting value and C2 has the amount you want to subtract.

1. Click the empty cell where you want the result.
2. Type =
3. Click the first cell, such as B2.
4. Type -
5. Click the second cell, such as C2.
6. Press Enter.

Your formula will look like =B2-C2. If B2 contains 150 and C2 contains 45, Excel returns 105.

Order matters. =B2-C2 is not the same as =C2-B2. If you flip the cells, you flip the sign of the answer. That matters when you’re working with balances, margins, or counts where a negative number changes the meaning of the result.

What The Formula Is Really Doing

Excel formulas begin with an equals sign. After that, Excel reads the cell references and the math operator. Microsoft’s overview of formulas in Excel explains that a cell reference tells Excel where to pull the value from, which is why formulas update when the source cells change.

That link matters because many beginners type the numbers straight into the formula. That works once, but it’s brittle. A reference-based formula stays live. Change B2 or C2, and the result changes with no rewrite.

When To Type The Cells Instead Of Clicking

Clicking cells is easier when you’re new. Typing references is faster once you know the grid. Both methods produce the same result. If you already know you need =D5-E5, just type it and press Enter.

Typing is handy when the cells are off-screen, when you’re working from a written formula pattern, or when you’re editing many formulas in a row.

Common Ways People Subtract Values In Excel

There isn’t a built-in SUBTRACT function in Excel. Microsoft says to use the minus sign for direct subtraction, or use SUM with negative numbers when you’re working across a range. The official Subtract numbers in Excel page spells that out.

For two cells, the minus sign is the cleanest choice. It’s short, easy to scan, and easy to audit later.

Here’s where each subtraction style fits best.

How To Copy The Subtraction Formula Down The Column

Most of the time, you won’t subtract just one pair of cells. You’ll do it for ten rows, a hundred rows, or more. Excel is built for that.

Once your first formula is working, click the result cell again. Move your cursor to the lower-right corner until you see the small fill handle. Drag it down, or double-click it if the rows next to it are filled. Excel copies the formula pattern down the column.

If your first row contains =B2-C2, the next row becomes =B3-C3, then =B4-C4, and so on. Microsoft’s Fill a formula down into adjacent cells page shows the same behavior.

Why The Formula Changes As You Fill

This happens because Excel uses relative references by default. Relative means the formula shifts with the row. That’s what you want in most subtraction tables.

Say you have this setup:

• Column B: Sales
• Column C: Refunds
• Column D: Net sales

In D2, type =B2-C2. Then fill down. Every row will subtract the cells on that same row. No hand typing needed.

When You Need To Lock One Cell Reference

Sometimes one side of the subtraction should move and the other should stay fixed. Say column B holds prices, and cell F1 holds a flat discount. You want each row to subtract the discount in F1.

Use this formula:

=B2-$F$1

The dollar signs lock that reference. When you fill the formula down, B2 becomes B3, B4, and B5, but F1 stays F1.

This is one of the most useful patterns in Excel. If you skip the dollar signs, the formula drifts downward and starts subtracting the wrong cells.

Why Your Excel Subtraction Result Looks Wrong

If the subtraction answer looks odd, the formula is often fine and the cell format is the problem.

Dates Showing As Serial Numbers

Excel stores dates as serial values. If you subtract one date from another, the result is the number of days between them. That’s normal. You may just need to format the result cell as a number instead of a date.

Times Showing A Strange Decimal

Excel stores times as fractions of a day. A result like 0.25 means six hours. Change the result cell to a time or custom format if you want it to read as hours and minutes.

A Result Of ######

This usually means the column is too narrow for the display. Widen the column first. If it still shows hashes and you’re subtracting times or dates, the result may be negative and your current format can’t show it cleanly.

You See The Formula Instead Of The Answer

If Excel shows =B2-C2 in the cell instead of the result, the cell may be formatted as text. Change the format to General, then re-enter the formula.

The Answer Does Not Update

That can happen if calculation mode is set to manual. It’s not common in a basic sheet, but it does happen in inherited workbooks.

Best Setups For Everyday Subtraction Tasks

Budget Tracking

Use one column for planned spend and one for actual spend. Then subtract planned from actual to spot overages or leftover room.

Inventory Counts

Subtract units sold from opening stock, or subtract damaged items from received stock to get the live count.

Sales And Refunds

Subtract refunds from gross sales to get a cleaner number for review. This is one of the most common row-based subtraction patterns.

Scores, Targets, And Gaps

Subtract current performance from target to see the gap. Reverse the order if you want a positive number to mean you’re ahead.

Simple Habits That Keep Your Formulas Clean

• Put labels above each column so the formula’s meaning is clear at a glance.
• Use the same row structure all the way down the table.
• Check the first three copied results before you trust the whole column.
• Lock fixed references with dollar signs when one cell should stay put.
• Format result cells as numbers, currency, dates, or time based on what the subtraction returns.

Once that pattern clicks, Excel feels a lot less fussy. You’re not just subtracting two cells anymore. You’re building a sheet that stays readable when the numbers change.

Send us your feedbackTell us what you thought about this post

Name * Email *

Your comment *

Quick check — what is …? *

Send feedback