Find the Place to Calculate Subtraction and Put equals to(=) Operator The numbers are showing in the image above from cell B3 to B7.Ģ. Place these numbers in a single column of the cell sequentially. Let’s take 17, 5, 7, 9 and 3 as the five numbers you have to calculate the difference. You have to follow the below given step-by-step process. If there are more than two numbers for which you have to calculate the subtraction. How To Find Difference of More Than Two Numbers in Excel The calculated result starts showing in the cell D4. This is the final step of this method where you have to press the ‘Enter’ button of the keyboard. Final Step is to Press Enter For the Final Result The above image showing the completed formula of subtraction which is read to give the output.Ĥ. Don’t forget to place the minus(-) sign between the numbers. On click of the cell, the name of the cell automatically gets inserted. Press the ‘CTRL’ button and hold it and mouse click the two numbers. Press ‘CTRL’ and Select Two Numbers By Clicking on it You have to place the equals to(=) operator in the cell D4 to start the formula in Excel.Ĭheck the above image contains the equals to(=) operator as the starting point of the calculation.ģ. Now, suppose you have to calculate the difference between these two numbers in the cell D4. Place equals to(=) operator Where you have to Calculate Subtraction

The cell is B4 and C4 with B4 contains the largest number and C4 contains the smallest number.Ģ. The above image showing the two number which you want to get the difference as the output. You have to use these numbers to calculate the difference between these two numbers. Put any two numbers in the cell which you want to find the subtraction. Subtract Two Numbers in Excel Using Minus(-) Operator Calculate Difference Between Two Columns in Excel.How To Find Difference of More Than Two Numbers in Excel.Subtract Two Numbers in Excel Using Minus(-) Operator.I tried with =INDEX(x1_array,MATCH(x2_array,y1_array,-1))īut it looks like an incomplete formula and I'm not even sure I'm doing it right, because of the differences in the column sizes. So far I've been doing it manually, but it is exhausting for a long tables and I was thinking that there should be a method in excel, which I can't figure our. Both x3 and 圓 have to be evaluated using x1,x2,y2 and 圓. 1.2&1.4) and 圓 should contain the value that results from subtracting y1 and y2, corresponding to the matching rows. In words, column x3 should contain the value that matches both x1 and x2 (with a condition that the numbers should be closer e.g. One that contains a number that matches column x1 and x2 and the second one that has the difference between the values corresponding to the row match, like in the table below: x1 y1 x2 y2 x3 圓 = y2-y1

I have the following table with four columns: > x1 y1 x2 y2Īnd I would like to have two more columns.

Excel formula subtract two columns