Subtraction Formula in Excel (7 ways)

We all know basic subtraction. It is mainly finding differences between two or more values. This article will show you subtraction formula in Excel that you can your excel workbook and improve your knowledge.


Download Practice Workbook


Basic Subtraction Formula

 
=number 1 – number 2 

There is no function to subtract in Excel. You have to perform subtraction using formula in Excel. Subtraction always starts with an Equal (=) sign. Otherwise, it won’t work.

This is how you can perform subtraction in a cell:

basic Subtraction formula in Excel

This will give you the result which is 100.

Subtraction result in Excel


7 Ways to Use Subtraction Formula in Excel

1. Subtraction Formula Between Two Cells 

You can perform subtraction of values from different cells using cell references. Here is a dataset which is showing a person’s salary and his expenses.

Subtraction dataset in excel

Now if we want to know about his Savings then we have to perform subtraction of his Expenses from his Salary. Here you can do it using cell references.

Subtraction formula in excel using cell reference

After that press ENTER. You can see the result.

Subtraction formula result

As you can see, we have successfully performed subtraction using a formula in Excel.

Read More: How to Add and Subtract Multiple Cells in Excel (3 Examples)


2. Subtraction Between Multiple Cells 

You can also do subtraction of multiple cells at once. The formula is also the same. 

Here you can see a dataset that shows a person’s salary and all his expenses. Now we want to know his savings which can be achieved by subtracting all the values from his salary.

Now add a cell named Savings. Here C2 cell is the salary. For finding savings, we are just subtracting every expense from his salary by following the Formula.

subtract formula in excel for salary

After entering that formula. Hit Enter and you can see the result.

result after subtraction formula

Read more: How to Subtract Multiple Cells in Excel (6 Effective Methods)


3. Subtraction Between Columns

Now, sometimes you can find yourself in a situation where you need to do subtraction of values between columns. You can also do it by cell reference.

a. Subtract Column Values

Here is a dataset of a shop that has product names, its purchase price, and selling price in different columns.

product dataset for subtraction

If you want to know the net profit for each product, you just need to subtract “Purchase Price” from “Selling Price”. 

All you have to perform is basic subtraction. Here we are subtracting cell D4 from cell C4.

subtraction formula for product

After you are done with your formula, press ENTER.

subtraction result for product dataset

Now drag the fill handle (“+” sign) across all those cells to copy that formula.

drag formula for copying

Here, you can see your desired result “Net Profit” for each product.


b. Subtract a Specific Value from a Different Column

Sometimes there can be another situation that you need to perform subtraction for a specific value from another cell from an entire column. You can do this by absolute cell references. If you don’t know about absolute cell reference then please check our article about  “What is and How to Do Absolute Cell Reference in Excel?”

Here is a dataset that shows different people’s amounts. Now, a particular fee is needed to be deducted from their amount. The fee is given in cell G3. 

Now, we have to subtract that fee from each of their amounts. You have to use absolute cell reference $G$3 for that fee.

subtraction formula in the cell

Then press Enter.

Now, drag that cell to copy your formula across the entire column. It will give you the amount that has been left after deduction.

subtraction formula in excel

Read More: How to Subtract Columns in Excel (6 Easy Methods)


4. Subtraction Formula for Percentages in Excel

The basic formula will work fine when you are doing subtraction between percentages.

=75% – 25%

You can also do it by cell reference by following:

=B3-C3

Subtraction Formula for Percentages in Excel

Press ENTER

Subtraction Formula for Percentages in Excel

You can subtract a percentage from a number. It means a decrease by percentage. 

= number* (1 – percentage)

You can reduce an amount by 30% by this:

= 1000 * (1 – 30%)

You can do it by cell reference in excel. 

=B3*(1-C3)

Here is a dataset of some businessmen who have invested in the Stock Market and lost a percentage of their amount.

We are gonna find how much money remains after calculating loss by using our decrease by percentage formula.

Subtraction Formula for Percentages in Excel

Hit Enter. It will show the remaining amount.

Now, drag the formula to the end of that column to get all those remaining amounts.

Subtraction Formula for Percentages in Excel

Read More: How to Subtract in Excel Based on Criteria (3 Suitable Examples)


5. Formula for Dates 

No complexity around here to subtract between two dates. The following formula will work easily:

= End Date – Start Date

Subtraction Formula for Dates in Excel

There are also a few ways you can do this using the following ways:

     =DATE(2021,5,1)-DATE(2021,2,12)
=DATEVALUE("2/1/2021")-DATEVALUE("19/1/2020")

6. Subtraction Formula for Time

This is also the same as subtracting dates. 

= End time – Start Time

Using Cell reference it will look like this:

=C3-B3
                                  

Subtraction Formula for Time


7. Subtraction Formula for Text

Now you might ask whether you can subtract a text from another text using the minus(-) sign. The answer is No, you can’t. But we can subtract a specific word or text from another text value. But you have to do this with the help of other functions.


a. Subtract Formula for Case-Sensitive Text

To subtract a text of a cell from another cell, we are gonna use TRIM and Substitute function. 

The substitute function will replace the text from desired text with a space.

Then Trim function will remove that extra space.

=TRIM(SUBSTITUTE(B3,C3,""))

The above formula will work like this:

Subtraction Formula for Text


b. Subtract Formula for Case-Insensitive Text

The previous formula will remove exact text from the Name. But if you don’t want your formula to be case-sensitive then you can use the following formula:

=TRIM(REPLACE(B3,SEARCH(C3,B3),LEN(C3),""))

The SEARCH function returns the position of the first character to subtract within the original string, ignoring the text case. 

This number goes to the start number argument of the REPLACE function

The LEN function is basically to find the length of the substring that should be removed. This number goes to the num_chars argument of REPLACE.

Here you can see C4 is the substring that we want to remove from B4.

Subtraction Formula for Text


Conclusion

These formulas will definitely help you for improving your Excel knowledge. To get the best out of it, you must try it on your own. If you want to know more about Excel’s functions and formulas, make sure you are checking our website Exceldemy.com other Excel-related articles.


Related Articles

Shanto

Shanto

Hello! I am Shanto. An Excel & VBA Content Developer. My goal is to provide our readers with great tutorials on various Excel-related problems. I hope our easy but effective tutorials will enrich your knowledge. I have completed my BSc in Computer Science & Engineering from Daffodil International University. Working with data was always my passion. Love to work with data, analyze those, and find patterns. Also, love to research. Always look for challenges to keep me growing.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo