To do so, you can go through the steps mentioned below. Instead of this, you can add them to the formula by picking the corresponding cells. However, it is not necessary to type cell references manually. If you want to subtract the figure in B2 from the figure in A2, you can use this formula (=A2-B2). But, in this case, you need to supply cells instead of the numbers. In Excel, you can also subtract one cell from another using the minus formula. =100-20-30 How to Subtract Cells in Excel? For instance, to subtract multiple numbers from 100, you can type those numbers separated by a minus sign as shown below. Step 4: As the last step, you can hit the Enter key to complete the formula.Īpart from that, you can perform more than one arithmetic operation within a single formula. Step 3: After that, you can enter the second number which should be subtracted with the first number. Step 2: Then, you can enter the first number with a minus sign. Step 1: To enter the subtraction formula in Excel, you can type the equality sign (=) in a cell (where you want the result to display). Below are the following steps on how to subtract in excel formula.
For instance, you want to subtract 1 from 10, you can write the equation =10-1 and get 9 as a result. However, you can use the basic subtraction formula which is a minus sign (-). The subtraction function does not exist in Excel. What is the Subtraction Formula in Excel?
If you regularly use Excel then you might be aware of its subtraction formula. It not just saves plenty of time but also makes you productive at the professional front. There are a number of ways to use the subtraction formula in Excel.
0 kommentar(er)
