Step 4: Once done, click on the cell that contains a subtrahend (a quantity to be subtracted) in order to add its reference to the formula (B2). Step 3: Thereafter, you can enter the minus sign (-). Doing so, the reference will be added to the formula (A2) automatically. Step 2: Now, you can click on the cell that contains a minuend (a quantity from which another number needs to be subtracted). Step 1: To begin, type the equals sign (=) in a cell where you want the output to appear. 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?

Formula for subtracting percentage in Excel.

Subtract the same number from a column of numbers.

The tutorial focuses on the following subtraction formulas: 91 Tips for Calculating with Microsoft Excel - Improve Your Excel Calculation Skills in No Time with These Short, Simple Tutorials

Formula in excel to subtract