How to Subtract in Excel?

Subtraction is one of the most fundamental operations you will ever perform in Excel. Whether you are calculating profit margins, tracking budget variances, measuring time differences, or comparing sales data, knowing how to subtract in Excel quickly and correctly is a skill every spreadsheet user needs.

Here is the important thing to know upfront: Excel does not have a built-in SUBTRACT function. Instead, it uses the minus sign (-) operator directly in formulas. This keeps things simple, but the power comes from knowing all the ways you can apply it, across single cells, entire columns, percentages, dates, times, and more.

This guide covers every method, from the most basic formula to advanced scenarios, with practical examples you can use immediately.

Read Also: How to Create Dashboard in Excel? A step-by-step Guide

The Basic Excel Subtraction Formula

The simplest subtraction formula in Excel follows this structure:

Example: subtracting hard-coded numbers:

Result: 350

Example: subtracting with multiple values:

Result: 320

Using parentheses to control order of operations:

Excel follows PEMDAS (Parentheses, Exponents, Multiplication/Division, Addition/Subtraction). When you mix operations, parentheses determine what gets calculated first:

Without parentheses, Excel would divide 100 by 80 first, then handle the subtractions, giving a completely different result. Always use parentheses when combining operations.

Also Read: What is Power Query?

How to Subtract Cells in Excel?

Rather than typing numbers directly into a formula, the smarter approach is to reference the cells that contain those values. This way, if your source data changes, the result updates automatically.

Syntax:

Example: If A4 contains 3,500 and B4 contains 1,200, enter this in C4:

Result: 2,300

Step-by-step:

1. Click the cell where you want the result (e.g., C4).
2. Type =
3. Click cell A4, its reference is added automatically.
4. Type -
5. Click cell B4.
6. Press Enter.

Subtracting multiple cells from one cell:

Method 1: Chained minus signs:

Method 2: Using SUM (cleaner and more scalable):

Method 2 is preferred for longer lists as it is easier to read and maintain.

How to Subtract an Entire Column in Excel?

When you have two columns of data and need to subtract each row, you do not need to type a formula for every row. Write one formula and copy it down.

Example:

• Column B contains sales targets.
• Column C contains actual sales.
• Column D should show the variance (actual minus target).

In D2, enter:

Then drag the fill handle (small square at the bottom-right of D2) down to D10 (or however far your data goes). Excel automatically adjusts the row references for each row.

Result:

Tip: Double-clicking the fill handle (instead of dragging) automatically fills the formula down to the last row that has data, a big time saver on large datasets.

Related Article: How to Compare Two Columns in Excel?

How to Subtract a Fixed Value from an Entire Column?

Sometimes you need to subtract the same number from every value in a column, for example, applying a flat deduction, discount, or tax adjustment across all rows.

Method 1: Store the fixed value in a cell and use an absolute reference:

Put the deduction amount in cell B2 (e.g., 500). Then in B2:

The $ signs lock the reference to E2, so when you copy the formula down, A2 becomes A3, A4, etc., but $E$2 always stays fixed.

Method 2, Hard-code the fixed value:

This works, but Method 1 is more flexible. If the deduction amount changes, you update one cell (E2) instead of editing every formula in the column.

Method 3, Paste Special (no formula needed):

1. Type the number to subtract (e.g., 500) in any empty cell.
2. Copy that cell (Ctrl+C).
3. Select the column range you want to subtract from (e.g., A2:A20).
4. Right-click → Paste Special → select Subtract → click OK.
5. Excel subtracts the value from every cell in the range in place, no helper column needed.

How to Subtract Percentages in Excel?

Scenario 1, Subtract one percentage from another:

If A2 is 75% and B2 is 30%, the result is 45%.

Scenario 2, Reduce a value by a percentage (e.g., apply a 20% discount):

Example: A2 = 8,000 (original price), B2 = 20% (discount).

Result: 6,400

This formula works by first calculating what remains after the discount (80% of the original), rather than subtracting 20% separately, which is mathematically the same and simpler to read.

Also Read: XLOOKUP() vs. VLOOKUP()

Scenario 3, Calculate percentage difference between two values:

Format the result cell as a percentage to display it correctly.

How to Subtract Dates in Excel?

Excel stores dates as serial numbers (number of days since January 1, 1900), which means subtracting one date from another returns the number of days between them.

Basic date subtraction:

If A2 is 01/01/2025 and B2 is 31/03/2025, the result is 89 (days).

Important: Make sure the result cell is formatted as a Number, not a Date. If it shows a date-like value instead of a number, right-click the cell → Format Cells → select Number.

Find the number of working days between two dates (excluding weekends):

Find the number of months between two dates:

Find the number of years between two dates (e.g., age or tenure):

Read Also: How to Remove Spaces in Excel?

How to Subtract Time in Excel?

Just like dates, Excel stores time as decimal fractions of a day (1 hour = 1/24, 1 minute = 1/1440). This means you can subtract times the same way you subtract dates.

Basic time subtraction:

If A2 is 09:00 and B2 is 17:30, the result is 8:30 (8 hours, 30 minutes).

Important: Format the result cell as [h]:mm (not just h:mm) if the elapsed time might exceed 24 hours. To do this: right-click → Format Cells → Custom → type [h]:mm.

Convert the result to decimal hours:

Convert to total minutes:

Handle cases where end time is past midnight:

This adds 1 (one full day) to the end time when the shift crosses midnight, for example, a 10 PM to 6 AM shift.

Read Also: CALCULATE Function in Power BI

How to Subtract Using Paste Special (Without Formulas)?

If you want to subtract a value from a range of cells permanently, without using a formula column, Paste Special is your tool.

Steps:

1. Enter the number you want to subtract (e.g., 100) in any empty cell.
2. Copy it with Ctrl+C.
3. Select the range of cells you want to reduce (e.g., B2:B20).
4. Right-click → Paste Special (or Ctrl+Alt+V).
5. Under Operation, select Subtract.
6. Click OK.

Excel subtracts 100 from every value in the selected range and overwrites the original values. This is useful for quick bulk edits but note that the change is permanent, the original values are replaced.

How to Subtract Across Multiple Sheets

If your data is spread across worksheets, you can reference cells from other sheets directly in your subtraction formula.

Syntax:

Example:

• Sheet1 has January sales in A2.
• Sheet2 has February sales in A2.
• To find the change, on a summary sheet enter:

This is powerful for building monthly comparison dashboards or financial summaries across worksheets.

Also Read: KPI in Power BI: Key Performance Indicators Dashboards

Order of Operations: A Common Pitfall

Excel follows PEMDAS strictly. If you are combining subtraction with multiplication or division in the same formula, the order matters.

Always add parentheses whenever you combine operations to make your intention explicit and avoid unexpected results.

Quick Reference: All Excel Subtraction Scenarios

Related Article: What is Azure Virtual Machine?

Common Mistakes to Avoid

Here are some fo the most common mistakes a beginner can make while performing subtraction. You just have to avoid these silly mistakes for becoming a proficient expert.

1. Forgetting the equals sign Every formula in Excel must start with =. Typing A2-B2 without the = stores it as text, not a formula.
2. Using the wrong cell references when copying formulas If you forget to lock a reference with $ when subtracting a fixed value from a column, the reference shifts as you copy the formula down, and your results will be wrong. Always use $C$1 (not C1) for fixed references.
3. Date result showing as a date instead of a number When you subtract two date cells, format the result cell as Number, not Date. If Excel auto-formats it as a date, you will see something like "01/01/1900" instead of the number of days.
4. Time subtraction returning a negative result If your start time is later than your end time in the same row (e.g., a night shift), subtraction returns a negative number or #####. Use =IF(B2<A2, B2+1-A2, B2-A2) to handle overnight spans.
5. Mixing number formats in a range If some cells in your range are formatted as text (left-aligned), Excel may skip them or return errors. Ensure all values in your data range are stored as numbers.

Related Excel Skills Worth Learning Next

Subtraction is just the beginning. Once you have this down, these related Excel operations are the natural next steps:

• SUM function, adding up ranges efficiently
• SUMIF / SUMIFS, conditional addition and subtraction
• Percentage formulas, calculating growth, discount, and change
• DATEDIF, precise date difference calculations
• IF and Conditional Formatting, flagging variances automatically
• PivotTables, summarizing and comparing grouped data

To build these skills into a complete, professional Excel toolkit, explore these resources from igmGuru:

• ? Microsoft Advanced Excel Training, master formulas, functions, pivot tables, and data analysis end to end
• ? Power BI Training, visualize your Excel data in interactive dashboards
• ? Data Science with Python Training, go beyond Excel for large-scale data operations
• ? Excel Formulas Cheat Sheet, a quick-reference guide for all essential Excel formulas
• ⌨️ Excel Keyboard Shortcuts, speed up every task with the most important shortcut keys

Read Also: What is POML (Prompt Orchestration Markup Language)?

Conclusion

Subtraction in Excel is far more versatile than most people realize. The minus sign is your core tool, but knowing how to apply it to columns, fixed values, percentages, dates, and times, along with smart techniques like absolute references and Paste Special, transforms a simple operator into a powerful analytical tool.

Whether you are building a budget tracker, calculating project timelines, analyzing sales variances, or processing time logs, the techniques in this guide cover everything you need to do the job accurately and efficiently.

Frequently Asked Questions (FAQ)

Q1. Does Excel have a SUBTRACT function?

No. Excel does not have a dedicated SUBTRACT function. All subtraction is done using the minus (-) operator in a formula, like =A2-B2. For subtracting a range of values, you can combine it with SUM: =A1-SUM(A2:A10).

Q2. How do I subtract an entire column in Excel?

Enter your subtraction formula in the first row (e.g., =B2-C2), then drag the fill handle down or double-click it to copy the formula through the rest of the column. Excel adjusts the row references automatically for each row.

Q3. How do I subtract a fixed number from every cell in a column?

Use an absolute cell reference: store the number in a separate cell (e.g., E1) and write =A2-$E$1. The $ signs lock E1 so it does not shift when you copy the formula down. Alternatively, use Paste Special → Subtract to apply the deduction directly to the cells without a formula.

Q4. How do I subtract dates in Excel to find the number of days between them?

Simply enter =B2-A2, where B2 is the later date and A2 is the earlier date. Format the result cell as a Number (not Date) to see the day count. For working days only, use =NETWORKDAYS(A2,B2).

Q5. How do I subtract time in Excel and show the result in hours?

Use =(B2-A2)*24 to get elapsed time as a decimal number of hours. To show it in h:mm format, use =B2-A2 and format the result cell as [h]:mm via Format Cells → Custom.

Q6. What does ##### mean after subtracting dates or times?

It means the column is too narrow to display the value, or the result is negative (which dates and times cannot display). Widen the column, and if the result is truly negative (end time is before start time), use the overnight correction formula: =IF(B2<A2, B2+1-A2, B2-A2).

Q7. Can I subtract values across different sheets in Excel?

Yes. Use the sheet name followed by an exclamation mark: =Sheet2!A2 - Sheet1!A2. If the sheet name contains spaces, wrap it in single quotes: ='Jan 2025'!A2 - 'Dec 2024'!A2.