Guide: How To Subtract Numbers in MS Excel using Formula

Excel is a spreadsheet application with many features. One omission is a subtraction feature, which seems obvious. As such, Excel users manually enter formulas in the function bar to subtract numbers. These are some of the different ways you can subtract values in Excel spreadsheets. ..

Subtract by including values ​​in the formula

To subtract numbers in Excel, you don’t need to enter values into spreadsheet cells. You can include the values you want to subtract in the formula itself. First select a cell to add the formula to. Then click in the Excel function bar and enter ‘=’ followed by the values you need to subtract. For example, enter “= 25-5” in the function bar and press Enter. The cell of the formula returns the value 20. ..

Subtract cell references in spreadsheets

To subtract cell values in a spreadsheet, you must include their row and column references.

In cell B5, enter the formula ‘= B3-B4’. This will return the value 200 in cell B5. ..

Subtract one number from every value within a range of cells

If you need to subtract a single value from every number within a range of cells, you can copy the formula to other cells. For example, enter the values 25, 35, and 55 in cells C3: C5. Select cell D3, enter the formula ‘= C3-5’ in the function bar and press the Return key. D3 now subtracts 5 from 25 in cell C3. ..

Copy the formula in D3 to the other cells below it by selecting D3, clicking in the lower right corner of the cell and dragging it over the one below as shown below. Now the cells directly below D3 also add 5 to the numbers in C4 and C5.

Subtract the total of a range of cells from a single value

To subtract a column total for a group of cells from a single value, you can use the SUM function in a cell that adds the range, and then subtract that total with a separate formula. However, you can also subtract the total from a range of cells by including SUM in a formula.

To calculate the subtraction of two numbers, you can use the = sign. In cell B12, enter ‘= B11-SUM (B7:B9)’. This will return the value of 25 in cell B12. ..

Subtract two or more total cell range values

To subtract the total of the C7: C9 cell range from the previously entered B7: B9 range, enter the following formula in cells C7: C9: C7-B7=C9

Select C11 as the cell you want to add the formula to, then enter ‘= SUM (B7: B9) -SUM (C7: C9)’ in the function bar. Press Enter to add the function to the spreadsheet, which returns the value 100 in C11. So, by subtracting the C7: C9 cell range from the B7: B9 cell range, we get 175-75. ..

Subtracting percentage values ​​from grades

To subtract a percentage value, such as 50%, from a number, you must enter the value in a cell with percentage format. Then you can add a formula that subtracts the percentage from a number in another cell. Enter the value “150” in cell E3 as an example. You need to convert cell F3 to percentage format by right-clicking the cell and selecting Format Cells> Number> Percentage> OK. Enter ’50’ in F3, which will then be in percent format, as shown directly below.

Now you can subtract 50% from 150. Click on cell G3 and enter the formula ‘= E3- (F3 * E3)’ in the function bar. Cell G3 returns a value of 75, which is 50% of 150. So the formula subtracted 75 from 150.

Subtract values ​​from multiple worksheets

Excel allows you to subtract values between worksheets. For example, if you have a spreadsheet with cells B14 and B3, you can subtract B3 from B14 to get the desired result.

To add a formula to a cell in a spreadsheet, click on the B4 button in the Sheet2 row and enter the formula ‘= Sheet1! B14-Sheet2! B3 ‘in the Excel function bar. Then press Return. The cell will return a value of 50.

Some Excel formulas that subtract values are as follows:

  • Subtracting a number from another number
  • Subtracting two numbers
  • Subtracting three numbers
  • Subtracting four numbers
  • Subtracting five numbers
  • Addition and subtraction of two numbers

How To Subtract Numbers in MS Excel using Formula: benefits

Faq

Final note

This guide will show you how to subtract numbers in MS Excel using a formula. If you have any questions about this article, please don’t hesitate to ask us. Additionally, please share your love by sharing this article with your friends.

If you have any questions about how to subtract numbers in MS Excel using formula, then please ask us through the comment section below or directly contact us. Our education team is here to help you!