+ and – (that comes first from the left)įor learning more about Excel’s order of calculation, you may read the details here.

/ and * (which comes first from the left).

The following order is used for calculation:

The Excel follows the calculation order if you are using multiple operators in the formula. The following example displays the subtracted result of three cells (A, B, C) in the respective D cells. =10-5 An example of subtracting cells numbers The Excel will subtract the numbers and display the result in that cell. You can see, the numbers are typed directly in the cell preceded by the ‘=’. Alternatively, go to the formula bar and right the numbers for subtraction as shown below: The example of subtracting numbersįor subtracting numbers, you may directly write the numbers with minus sign in the desired cell. See the following section for using the minus operator in different examples. In that case, the cells containing negative values will be subtracted. For example:įor subtracting numbers in cell ranges, you may use the SUM function. Instead, you may accomplish the task of subtracting numbers or a cell’s value from the other by using the minus arithmetic operator (-). The following steps create a subtraction formula by using the plus sign “+”.There is no Excel SUBTRACTION function.

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 “+”.Subtraction Formula Using the Minus Sign “-“.

Subtract formula excel