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.
The steps to use Subtraction formula in excel is as follows –
0 kommentar(er)
