![excel subtraction formula excel subtraction formula](https://cdn.ablebits.com/_img-blog/subtraction/subtraction-formula-excel.png)
Select the cell C1, enter the formula =B1-A1, press Enter, return to 201 select C2, enter the formula =A2-B2, press Enter, return to -326, double-click C2, and add the absolute value function ABS into the formula, the formula becomes =ABS(A2-B2), press Enter, return to 326 the operation steps, as shown in Figure 3:
#Excel subtraction formula how to#
III, How to subtract in excel(with the minus sign)ġ. The formula =SUM(A1,-B1) returns a negative number, if a subtraction is required to return a positive number, just add the absolute value function ABS.
![excel subtraction formula excel subtraction formula](https://i.ytimg.com/vi/xYXAy7EUXmI/maxresdefault.jpg)
Double-click B1, copy the formula =SUM(A1,-B1) to C1, press Enter, return to -201 double-click C1 to add the absolute value function ABS into the formula, then the formula becomes =ABS(SUM(A1,-B1)), press Enter, return to 201 operation steps, as shown in Figure 2:
![excel subtraction formula excel subtraction formula](https://cdn.ablebits.com/_img-blog/subtraction/sum-suntract-excel.png)
If you want to substract the number in column B from the number in column A, the number in column A is small, and the number in column B is large. (II) The result of the subtraction is negative and is converted to a positive number by the absolute value.ġ. The - before A1 means minus in the formula =SUM(-A1,B1), the meaning of the formula is: subtract A1 from B1, that is, use the Sum function to calculate the subtraction by adding a minus sign(negative sign) before the subtrahend.
#Excel subtraction formula plus#
Double-click the cell C1, copy the formula =SUM(-A1,B1) to C1, press Enter, return to 201 select C1, move the mouse to the cell fill handle in the lower right corner of C1, and after the mouse turns the bold black plus sign, click the left button to return the result of remaining numbers the operation steps are as shown in Figure 1: If you want to subtract the number in column A from the number in column B. In addition, you can also use the minus sign(ie -) for subtraction.ġ. I, The description of subtract function in excelĮxcel does not provide directly a subtraction function, the subtraction operation requires the addition function, that is, the summation function Sum, the difference is that you only need to add a minus sign (negative sign) before the number to be subtracted. If you encounter a conditional subtraction, you need to use the If function to determine the condition if you encounter the digital with unit, you need to use the Left function and the Find function to intercept the number, and then calculate if required that the number that is involved in the calculation must have the ID, and it needs to be implemented in conjunction with the Indirect + Match + Row function if you want to reduce all the numbers in the table by one, you need to use the paste special in the calculation of the subtraction process. When calculating the subtraction with the Sum function, you only need to add a minus sign before the subtraction use the minus sign to calculate the number by one minus one. There are two ways to calculate subtraction in Excel, one is to use the addition function(that is, the summation function) Sum, and the other is to use the minus sign.