These features rely on cell references to other cells to make calculations. You can also do exponents, change order of operations, and do various mathematical functions in Excel.

The following steps create a subtraction formula by using the plus sign “+”. You can subtract, divide, multiply, and add in Excel within the cells of a spreadsheet. The number 3, stored in cell B3 has a minus sign in front of it, meaning that the number 3 is stored as a negative number. So, even though using the plus sign “+” the result is the same as the subtraction formula.įor example, there are data such as the image below (see the 3rd line). You can use a plus sign “+” for a subtraction formula with a condition, the number stored in the cell must be a negative number. Subtraction Formula Using the Plus Sign “+”

Point cursor to cell B2 (Cell containing number -3).

Point cursor to cell A2 (Cell containing number 5).

The following is the steps how to write subtraction formula How is the subtraction formula in Excel for number 5 subtract by number 3?įor example, number 5 and number 3 are stored in a cell as shown below (see line 2). You can type the numbers involved in the subtraction directly in the formula or place the numbers in a cell.įor example, there are two numbers, number 5 and 3. The symbol used for the subtraction formula is a minus sign “-” as well as a sign used in a mathematical operation. Subtraction Formula Using the Minus Sign “-“ Subtraction Formula Using the SUM Function.Subtraction Formula Using the Plus Sign “+”.In this way, we input the numbers directly in the formula. 1) Using numbers directly in the formula. Instead, we use the regular minus (-) symbol to perform subtractions. In MS Excel, you will not find any SUBTRACT function to perform the subtraction operation. Subtraction Formula Using the Minus Sign “-“ How to find the difference between two numbers in Excel using Formula.Thanks for your patience in reading this article. Visit our website, Exceldemy, a one-stop Excel solution provider, to find out about diverse kinds of Excel methods. For a better understanding, please download the practice sheet. Please let us know in the comments section if you have any questions or suggestions. And these are some easy methods to create a subtraction formula in Excel. We have provided a practice section on each sheet on the right side for your practice. Read More: How to Create a Formula in Excel (5 Ways) Basically, the SUM function adds the value of these two cells, but as we enter the negative signs in the D5 cell, so it takes all the values of the D column as negative.

Subtract formula excel