To obtain subtraction result from other numbers in the range drag down the formula. For example, the number to subtracted is written in cell B2 and while writing the formula we have locked the cell B2. Other option to obtain the same is to write the number in some cell and then lock the cell in the formula. Now drag down formula till you have values in the range to obtain subtraction result from other numbers in the range.Īs you can see we have subtracted number 19 from the values in the cell range A2:A6. Write the formula in some cell (in this example B2) and press enter. If you want to subtract a single value from all the values in the range. So, I have mentioned the cell references in my subtraction formula in cell C2. Like in the example below, the two numbers to be subtracted are present in cell A2 & B2. Then the subtraction formula should have the cell reference instead of actual numbers.

If the values to be subtracted are present in the cells. Like in the example below, I have written the formula “=53-26” in the cell A2.Īfter writing the formula press enter to display the result. To subtract two numbers, you simply have to write the formula in the cell you want the result to be displayed in. In this section, we will study subtraction in excel with the different type of values as described below: Subtract in excel allow us to minus numbers, cell values, numbers in columns, date, time and many more. We use subtraction to minus a number from another number.

We all are aware of the basic arithmetic operations which are addition, subtraction, multiplication & division.

Formula to subtract in excel