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 an Excel spreadsheet, 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 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, you must include their row and column references in the formula. For example, to subtract the values 345 and 145 in cells B3 and B4 in a blank Excel spreadsheet, you would enter the following: ..

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 subtract 5 from 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.

For example, enter the values ​​’45 ‘,’ 55 ‘and’ 75 ‘in cells B7 through B9. Then enter ‘200’ in cell B11. Select cell B12, click in the fx bar and enter ‘= B11-SUM (B7: B9)’ in the formula bar. Cell B12 will then return the value of 25, as shown directly below. That effectively subtracts the total of cells B7: B9 from 200 in cell B11.

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.

To subtract 50% from a number, you can use the formula ‘= E3- (F3 * E3)’. This formula subtracts 50% from the number in cell G3, which is 75 in this example. ..

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

In this guide, we will show you how to subtract numbers in Microsoft Excel using a formula. This is a handy technique if you need to do a lot of subtraction in your work, or if you want to be able to do it quickly and easily. ..

If you have any questions about this guide or tutorial, please comment below or contact us directly. This guide is for educational purposes only. If you want to correct any misinformation about the guide, please contact us. If you want to add an alternate method to the guide, please contact us. Our contact page is here if you need help. You may also use our social and accounts on Facebook, Twitter, and WhatsApp for your questions. We answer questions within 24-48 hours (weekend off). ..