A percentage to subtract is given in C2 to C6 cell. For that, the numbers are given from B2 to B6 cells. The following example shows the subtraction formula for subtracting the given percentage from a number. You can see, theExcel SUM function returned the result after subtracting the negative numbers. The sum formula for subtraction of numbers: In that case, the cells containing minus numbers will be subtracted. Using the SUM functionįor displaying the result in the specified cell, you may also use the SUM function of Excel. The sum is returned by subtracting the negative number. You can see, the cell contains negative and positive numbers. The Excel automatically displays the sum, count, and average of selected cells as shown in the graphic below: If you simply require viewing the calculation of multiple cells that contain negative and positive numbers then select the range of cells and look at the Status bar in Excel. =3-2*10 = 17 The example of subtracting a range of cells Without parenthesis, through subtraction came first from the left, it was first multiplied and then subtracted. In formulas where parenthesis is used, Excel first subtracted and then multiplied. See an example below where I used multiple operators for calculation.
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 (-).
0 kommentar(er)
