How to Subtract in Excel Latest Guide 2021

Subtraction is the most basic arithmetic process. The good thing is that you can do the same job in excel within a few minutes. So here you will learn how to subtract in excel.  You can subtract anything in excel like the form percentage to the date and time so get ready to find more about it.

How to Subtract in Excel

How to Subtract in Excel Latest Guide 2020

It is time to start learning of How to Subtract in Excel with the latest ways that will able to help you in the latest version of excel.

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 about 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 :

  1. first, you need to enter the dates in individual cells and subtract 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 date 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”)how to subtract in excel (1)

 

 

It is not an easy method to learn how to subtract dates in excel. So get to the next subtracting method.

How to Subtract Cells in Excel?

Sometimes you need to subtract one particular cell from 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 from 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 references of the cells manually add the column number and the segment and you go. Undeterred the points mentioned below

  1. In a cell you like to output a difference; you need to type the sing = to start the formula.
  2. 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.
  3. Once you have done this, you need to place the sign (-).
  4. after that click the cell consisting of the subtrahend( it is the number that you want to subtract from the value) to incorporate the reference to formula (B1)
  5. After doing all this, you need to enter the key Enter from the ley boars. It will execute the formula.how to subtract in excel

how to subtract dates in excel

Let learn more about the 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 the time in Excel. So get r4eady 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_timeStart_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 the 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”)how to subtract cells in excel

The excel office is a bit tricky but not complicated. The little grip on the basics 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)

how to subtract a percentage in excel

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.

Also read: How to Lock Cells in Excel

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 the fill handle or double click the + to copy the given formula to an entire column

Let’s Take the example. Here you subtract the 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 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

  1. place your cursor on the Cell C1 
  2. after that type =
  3. Move your cursor to the A1 column  
  4. once you have done this, you need to place minus sign
  5. After that, place the mouse n the B1 and make the absolute reference by holding the Key F4 once.
  6. Once you have done this, hit the ENTER button from the ley boars, and here you go.

How do you find this method? 

Now you can start work on excel. Now you have learned to subtract the cells in excel. Office.com is an online version of MS office that you can use to practice it.

Conclusion:

Have you tries the formula above in your excel office? If yes then let us know. These are the most simple and quick ways to subtract anything. If you have any more queries in How to Subtract in Excel then just ask us with the help of the comment box. 

Leave a Comment