TF Admin 
Microsoft Excel is well used for calculations, analyse data etc and reporting ridge. One of the most basic but very required operations is the subtraction of two things. Whether you’re calculating expenses, or finding the difference between data, or getting rid of some unwanted text to your articles, knowing the correct subtraction formula in Excel can save time and improve accuracy.
Unlike addition (which is based on functions such as SUM), the Excel Program does not have any “SUBTRACT function. Instead, it has a simple min (-) operator for subtraction.
In this guide, you’ll learn how to perform this subtraction of numbers and subtracting cells and multiple values, including subtraction of text strings in Excel.
Simple Formulas for Subtraction in Excel
The most basic of the formulas for subtraction is the use of the minus (-) operator.
Syntax:
=number1 – number2
Example:
=50 – 20
Result: 30
You may also subtract many numbers:
=100 – 20 – 10
Excel works step by step in order to calculate the result.
Subtracting Cells in Excel
Instead of typing in numbers which you can refer to in cells.
Example:
| A1 | B1 | Result |
| 50 | 20 | =A1-B1 |
Formula:
=A1 – B1
This method is dynamic – if values change result change automatically.
Subtracting Multiple Cells
You can take a lot of things away from one cell.
Method 1: Using Minus Operator
=A1 – A2 – A3 – A4
Method 2: Using SUM Function
=A1 – SUM(A2:A4)
This is more hygienic and convenient when dealing with big datasets.
Calculating The Difference Between Columns In Excel
To subtract values row by row:
=A2 – B2
Then drag down the formula to be applied to all of the cells in the column.
This is useful for:
- Profit calculations
- Comparing datasets
- Financial analysis
Subtracting from a Column Using a Constant Value
If you want to subtract the same value from a group of cells:
=A2 – $B$1
Here, $B$1 is absolute, which means that it does not change if we copy the formula.
Making Percentages Using Excel (Subtraction)
You subtract percentages the same way that you subtract numbers.
Example:
=A1 – B1
If A1 = 100 and B1 = 20%, result = 80
Or use:
=A1 * (1 – B1)
This is usually used when it is discount or deductions.
Subtracting Dates and Time
Excel actually stores dates as numbers and as such the subtraction works as it always does.
Subtract Dates:
=B1 – A1
Return: No of Days in between two dates
Subtract Time:
=End_Time – Start_Time
This is good when keeping track of lengths of time or hours worked.
Removing Texts with Subtract Function in Excel (Remove Text String)
Excel doesn’t “subtract” text the way you do with numbers, but you can subtraction text with the help of functions.
Using SUBSTITUTE Function:
=SUBSTITUTE(A1, B1, “”)
A1 = Original text
B1 = Text to remove
Example:
A1: “Hello World”
B1: “World”
Result: “Hello ”
This method is very common in a process known as cleaning the data or bringing out useful data from the data.
Other Useful Functions for Erasing Text
Apart from the function SUBSTITUTE, you can have:
LEFT → extract text from left
RIGHT → extract from right
MID → extract from middle
These functions have help when you are doing complicated text manipulation.
Common Mistakes to Avoid
1. Forgetting “=” Sign
All formulas need to begin with =
2. Wrong Cell References
Be sure to make correct selections to cells
3. Formatting Issues
Sometimes results will come in the format of dates – change format to “General Structure”
4. Using Texts as Substitutions for Numbers
To subtract text values in Excel, the Excel tool cannot subtract text directly.
Tips for Better Use
- Refer to cell references rather than hard values
- Use SUM for large datasets
- When You Need Absolute References ($)
- Keep formulae simple and easy to read
Conclusion
The subtraction formula in Excel is relatively easy to use, but very powerful. The minus (-) operator can be used to subtract numbers, cells, columns, percentages, and even dates with ease.
For the text-based operations, functions like SUBSTITUTE are helpful to remove the unwanted strings in a good way.
Also Read: When Is Software Qugafaikle5.7.2 released?
About the Author
