Suppose we must determine the discount amounts for the items in the first table as the difference between the respective marked and selling prices. The first table contains the marked and selling price details for five items.Īnd the second table shows the reduction factor of $100 for the marked prices specified in the first table as a holiday offer.
Let us see how to use the Excel Subtraction formula to subtract columns. And the above three formulas show the different ways to represent the subtrahend or the total daily calorie intake value in the formulas. In all the above formulas, the minus sign precedes the values we aim to subtract from the required daily calorie value of $2,500.
Step 1: Select the target cell B9, enter the below formula, and press Enter.Īlternatively, the below formulas will get you the same results.Then, here is how you can apply the Subtraction formula in the target cell and get the required data. Suppose the requirement is to determine the calorie shortage as the difference between the daily calorie required and total intake and display the output in cell B9. The cell range A3:B7 shows the daily calorie intake breakdown, and cell B7 shows the total daily calorie intake as the sum of the calories contributed by the three nutrients, 2200. The below image shows the calorie data of a person.Ĭell B contains the required daily calories, 2500. The following Excel Subtraction formula example shows the different ways of subtracting Excel cells. The resulting savings in cell D7 is negative as the expenses are more than the specified June month income.Ĭheck out the below Excel Subtraction formula examples to use the formula effectively. It subtracts the second value from the first to return the difference of -$600. The Subtraction formula takes the cell references to the June month’s income and expenses values, $1,500 and $2,100, as input. Let us consider the cell D7 expression to see how the formula works. Using the fill handle, enter the formula in cell range D3:D7.=B2-C2 Entering the input values directly in the Subtraction formula will give the same result. Select the target cell D2, enter the Subtraction formula, and press Enter.The steps to use Subtraction formula in excel is as follows –
0 kommentar(er)
