Excel Subtraction Formula (Table of Contents)
Subtraction Formula in Excel (Minus Formula)
Excel provides various formulas for basic and advanced calculation and they have used for different purposes. If you want to add two or more numbers or calculate the average of numbers, Excel provides the inbuilt function for them and also they are available in Excel Ribbon too. Excel doesn’t provide the subtraction formula separately, hence what if we want to minus or subtract one value from another value.
There are a lot of ways to apply the Subtraction formula. Here in this article, we will learn how to subtract one number from another number.
What is the Subtraction Formula in Excel?
In Excel, the formula starts with a ‘=’ (equal) operator. If you want to subtract two or more numbers then you need to apply ‘-‘ sign (minus) operator between these numbers with ‘=’ sign.
If you want to subtract 2 and 5 from 15, then you need to apply below formula like this:
The result is: 8
How to Use Subtraction in Excel?
The excel subtraction formula is very easy. For this formula, you need to use Subtraction or Minus operator.
We will learn this with below example.
We have some number of values given as below:
Here we want to subtract Values 1 from Values 2. Please check below screenshot for this.
- Start with the ‘=’ operator.
- Now select values 2, here Cell B4. Use subtraction operator ‘-‘ after that. Now select Values 1, here Cell A4.
- Hit Enter key and it will show the result in Cell D4.
- Apply the same steps in other respective values. Or Drag this formula for other values.
The final result is shown below:
If you change the data in Cell A or Cell B, the result will automatically get changed in Column D.
We have to give the performance bonus which is 10,000 Rs. Of Gift voucher to those employees who have achieved the target of 5000.
Below are the data of 10 employees:
We have to calculate here those employees who have done the sales of 5000 Rs or more.
For this, we will apply the formula in excel and will subtract the target amount from the sales amount for all employees. Please see below screenshot:
As we have the target amount is the same for all employees, hence we need to fix this value for all.
We will use $ sign before the column letter and row number. Here like $C$19.
The formula is:
The Final result is:
For those employees whose achieved target value is negative, are not applicable to the performance bonus.
Types of Subtraction Formula in Excel
As we discussed above, there are many ways to perform the Excel subtraction Formula. Below are the types of Subtraction formula:
#1 – Subtraction between simple numbers (as shown in Example 1):
#2 – Subtraction between 2 or more cells:
When you have to subtract 2 or more cell values then use cell address for those values.
For Example: If you want to subtract values in Cell A1, A2, A3 from Cell B1 then use below formula:
3 – Subtract all the given values from one value (as shown in Example 2)
Sometimes in any business, this problem arises when we have to calculate how much inventory items are unprofitable or in the loss. In this condition, we need to subtract the profitable items from the total inventory.
Things to Remember about Subtraction Formula
- The Excel subtraction formula start with ‘=’ sign.
- Use ‘-‘ minus sign for subtraction of values.
- It’s very easy to use where you want to compare the values.
- Subtraction formula in excel is very useful for complex mathematical problems too.
- Subtraction formula can be used in combination with other mathematical operators.
This has been a guide to Subtraction Formula in Excel. Here we discuss how to use Minus Formula in Excel along with excel example and downloadable excel templates. You may also look at these useful functions in excel –