Subtraction Formula in Excel
※ Download: What is the excel formula for subtraction
Not only subtraction, you can also perform other excel functions such as division and addition. Copy the formula in D3 to the other cells below it by selecting D3, clicking the bottom right corner of the cell and dragging it over the ones below as shown below.
Subtract one list from another Supposing, you have two lists of text values in different columns, a smaller list being a subset of a larger list. When you use cell references in a formula instead of the cell value, you can change the value without having to change the formula.
Add and subtract numbers - This good old method works in Excel too.
How to subtract in Excel? There is no Excel SUBTRACTION function. In that case, the cells containing negative values will be subtracted. See the following section for using the minus operator in different examples. The example of subtracting numbers For subtracting numbers, you may directly write the numbers with minus sign in the desired cell. The Excel will subtract the numbers and display the result in that cell. See an example below where I used multiple operators for calculation. In formulas where parenthesis is used, Excel first subtracted and then multiplied. The Excel automatically displays the sum, count, and average of selected cells as shown in the graphic below: You can see, the cell contains negative and positive numbers. The sum is returned by subtracting the negative number. Using the SUM function For displaying the result in the specified cell, you may also use the SUM function of Excel. In that case, the cells containing minus numbers will be subtracted. The example of subtracting percentage The following example shows the subtraction formula for subtracting the given percentage from a number. For that, the numbers are given from B2 to B6 cells. A percentage to subtract is given in C2 to C6 cell. For copying the formula, write the complete formula in D2 cell. Now bring the mouse pointer to the right bottom of D2 cell until + sign appears with solid line. Drag the handle down to D6 cell and you will see the results corresponding to B and C values. Subtracting two dates example The following example shows subtracting two dates by using the minus arithmetic operator. The Start and End dates are given in A2 and B2 cells. You may learn more about date subtraction in its detailed tutorial:. The example of subtracting time You may also use the minus operator for subtracting time and get the difference in hours, minutes and seconds between two given times. In this example, the cell A2 is given 7:30 AM and cell B2 5:45 PM.
Subtracting two dates example The following example shows subtracting two dates by using the minus arithmetic operator. Note: If you see a date instead of the result that you expected, select the cell, and then on the Home tab, under Number, click General on the pop-up menu. If you need to display the formula instead of the result of the formula, then will show you what changes you need to make for that to occur. The total is 86. To execute subtraction, you have to use the cell references. If you used the example numbers, the result is 2.
