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.
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)
