Learn How To Subtract In Excel
Subtraction is the most basic arithmetic process. The good thing is that you can do the same job how to subtract in excel within a few minutes. So here you will learn how to subtract in excel. You can subtract anything in excel like form percentage to the date and time so get ready to find more about it.
How To Subtract Dates in Excel
If you are new on an excel sheet, then you must be unfamiliar with the Excel word function of these offices. It can add, it can subtract, and much more. You must be thinking how to subtract in excel. Now you will learn how to subtract dates in excel. So let’s start with the dates.
It is not at all a difficult method. There are a few steps that you need to follow to find out how to subtract dates in excel.
So get ready to find out more about it. you need to follow the steps mentioned below :
- first, you need to enter the dates in individual cells and subtract the one specific cell from the others, and here you go.
=End_date – Start_date
here are the tips you can also input the dates directly into the formula. You can do this with the data value or date function. Let us take the following example.
=DATE(2019,3,2)-DATE(2019,2,2)
=DATEVALUE(“3/2/2019”)-DATWVALUE(“2/2/2019”)
It is not easy methods to learn how to subtract dates in excel and How To Subtract In Excel in the Screenshot: So get to the next subtracting method.
How to Subtract Cells in Excel?
Sometimes you need to subtract the one particular cell form the other. In this, the minus formula is the same. In this, you provide the cell reference rather than the numbers. So get ready to find out how to subtract in excel in terms of cells. Follow the steps mentioned below.
here is the formula with little alteration
=cell_2 – cell_3
For instance, if you would like to subtract the number B1 form the A1, then you need to follow how to subtract time in excel=A1-B1
Point to note: here you do not require to put all reference of the cells manually add the column number and the segment and you go. Undeterred the points mentioned below
- In a cell you like to output a difference; you need to type the sing = to start the formula.
- After that, click on a cell consists of the minuend(the numeric form that other figures are to be misused). The reference of this will automatically add to the formula that is A1.
- Once you have done this, you need to place the sign (-).
- after that click the cell consisting the subtrahend( it is the number that you want to subtract from the value) to incorporate the reference to formula (B1)
After doing all this, you need to enter the key Enter form the ley boars. It will execute the formula.
Let learn more about subtraction methods.
How to Subtract Time in Excel
You have learned how to how to subtract in excel in terms of date and cells. Now it’s time to learn how to subtract time in excel. The basic formula for it is the same. It is a more simple way to subtract time in Excel. So get ready to learn more about subtracting
You need to follow the formula mentioned below to find how to subtract time in excel. The formula is
=End_time–Start_time
Let us take an example of it. So that it will be clear for you.
You need t find the difference between the times mentioned in column A1 and B1. So follow the formula there that is
=A1-B1
If you want the accurate answer you need to apply a Time format to the given formula cell:
You can get the precise result by putting the value of times in a formula. You need to use the Time value formula to makes Excel understand the times perfectly
=TIMEVALUE(“5:35 PM”)-TIMEVALUE(“1:00 PM”)
The excel office is a bit tricky but not complicated. The little grip on the basic will help you in a long way. Now you know how to subtract in excel in terms of time also. So get back to the next subtraction.
How to Subtract a Percentage in Excel
Now you have a firm grip on how to subtract time in excel. But no, you will learn about how to subtract a percentage in excel. It is as simple as it looks. All you need is to bring little changes to the formula, and here you go. So you will use the previous minus method for instance
=100%-20%
if you don’t want to add the value, you can simply input the particular cells and minuses all cells. For example
A1-B1
Sometimes you require to minus the percentage forming the numeric that is reduced by the percentage, then you need to follow the formula given below, and that is
=Number * (1 – %)
From here you will get more clarification about it by following examples
A1 by 20%
=A1*(1-20%)
You can also enter the % in the specific cell like B1 and also refer to the cell by utilizing the absolute reference:
=A3*(1-$B$2)
These are some basic and straightforward methods to subtract the percentage. So let move to the best way of subtraction. Now you have a firm grip on how to subtract in excel in terms of date, time, cells, and percentage. So move to the next one.
How to Subtract Columns in Excel
Now you learn how to subtract a percentage in excel, so move to the how-to subtract columns in excel. t minus the two-column you need to pit the same minus method for the cells and then you have to drag fill handle or the double click the + to copy the given formula to an entire column
Let’s Take the example. Here you subtract C column from the B column. So follow the method mentioned below to learn how to subtract columns in excel.
=B2-C2
How do you find this method? Is it helpful for you? If yes, then move to how to subtract in excel in terms of multiple cells. The next process you will learn is as simple as you think. After learning this, you can subtract anything in the excel and find this software most helpful.
How to Subtract Multiple Cells in excel
Sometimes you need to subtract multiple cells in excel. For this, the methods are as simple as it looks. The formal remain the same, and you will get your desire function. So get ready to find more about the marvelous method and make your life easy.
You need to follow the steps mentioned below
- place your cursor on the Cell C1
- after that type =
- Move your cursor to the A1 column
- once you have done this, you need to place minus sign
- After that, place the mouse n the B1 and make the absolute reference by holding the Key F4 once.
- Once you have done this, hit the ENTER button form the ley boars, and here you go.
How do you find this method?
Conclusion:
Have your tries the formula above in your excel office? If yes then let us know. These are the most simple and quick way how to subtract in excel and subtract anything.
Leave a Reply