How to Subtract in Excel

This wikiHow teaches you how to subtract the contents of one or more Excel cells from another cell. Open Excel. It's a green app with a white 'X' on it.

Method 1 of 3:

Subtracting Cell Values

  1. Picture 1 of How to Subtract in Excel
    Open Excel. It's a green app with a white "X" on it.
    1. If you would rather use a pre-existing Excel document, instead double-click the Excel document in question.
  2. Picture 2 of How to Subtract in Excel
    Click Blank workbook (PC) or Excel Workbook (Mac). It's in the top-left side of the "Template" window.
  3. Picture 3 of How to Subtract in Excel
    Enter your data if necessary. To do so, click a cell, type in a number, and press ↵ Enter or ⏎ Return.
  4. Picture 4 of How to Subtract in Excel
    Click an empty cell. This will select the cell.
  5. Picture 5 of How to Subtract in Excel
    Type "=" into the cell. Exclude the quotation marks. You'll always type an "equals" sign prior to inserting a formula in Excel.
  6. Picture 6 of How to Subtract in Excel
    Type in a cell's name. This should be a cell with data from which you wish to subtract other cells' value(s).
    1. For example, you would type "C1" to select the number in cell C1.
  7. Picture 7 of How to Subtract in Excel
    Type - into the cell. You'll see it appear after the number you entered.
  8. Picture 8 of How to Subtract in Excel
    Type in another cell's name. This should be a cell whose value you wish to subtract from the first cell's name.
    1. You can repeat this process with multiple cells (e.g., "C1-A1-B2").
  9. Picture 9 of How to Subtract in Excel
    Press ↵ Enter or ⏎ Return. Doing so will calculate the formula entered in the cell and replace it with the solution.
    1. You can click on the cell to view the original formula in the text bar directly above the row of letters.
Method 2 of 3:

Subtracting Within a Cell

  1. Picture 10 of How to Subtract in Excel
    Open Excel. It's a green app with a white "X" on it.
  2. Picture 11 of How to Subtract in Excel
    Click Blank workbook (PC) or Excel Workbook (Mac). It's in the top-left side of the "Template" window.
  3. Picture 12 of How to Subtract in Excel
    Click a cell. Unless you plan on creating data using this workbook, the cell you select is not important.
  4. Picture 13 of How to Subtract in Excel
    Type "=" into the cell. Exclude the quotation marks. This will set the cell up for a formula.
  5. Picture 14 of How to Subtract in Excel
    Type in a number from which you wish to subtract. It will appear in your selected cell to the right of the "equals" sign.
    1. For your budget, for example, you might type your month's income into this cell.
  6. Picture 15 of How to Subtract in Excel
    Type - into the cell. You'll see it appear after the number you entered.
    1. If you decide to subtract multiple numbers (e.g., X-Y-Z), you'll repeat this step after each subsequent number excluding the last one.
  7. Picture 16 of How to Subtract in Excel
    Type in a number you wish to subtract from the first number.
    1. If you're calculating budget, you might type an expense into this cell.
  8. Picture 17 of How to Subtract in Excel
    Press ↵ Enter or ⏎ Return. Doing so will calculate the formula entered in the cell and replace it with the solution.
    1. You can click on the cell to view the original formula in the text bar directly above the row of letters.
Method 3 of 3:

Subtracting a Column

  1. Picture 18 of How to Subtract in Excel
    Open Excel. It's a green app with a white "X" on it.
    1. If you would rather use a pre-existing Excel document, instead double-click the Excel document in question.
  2. Picture 19 of How to Subtract in Excel
    Click Blank workbook (PC) or Excel Workbook (Mac). It's in the top-left side of the "Template" window.
  3. Picture 20 of How to Subtract in Excel
    Click a blank cell. Doing so will select it.
  4. Picture 21 of How to Subtract in Excel
    Enter your main number. This is the number from which the rest of the column will be selected.
    1. For example, you might type in your yearly salary here.
  5. Picture 22 of How to Subtract in Excel
    Enter any subtractions in the cells below. To do so, you'll type in a negative version of the number you wish to subtract (e.g., if you wish to subtract 300, type in "-300").
    1. You'll type in one subtraction per cell.
    2. Make sure each of the numbers you enter are in the same column as the main number.
    3. For the salary example, you'd likely type "-" followed by an expense for each box.
  6. Picture 23 of How to Subtract in Excel
    Click a blank cell. This time, the cell doesn't need to be in the same column as the main number.
  7. Picture 24 of How to Subtract in Excel
    Type "=" into the cell. Exclude the quotation marks. Doing so will set up the cell for a formula.
  8. Picture 25 of How to Subtract in Excel
    Type SUM into the cell. The "SUM" command adds items together.
    1. There isn't an official "subtract" command, which is why you enter numbers in the negative format above.
  9. Picture 26 of How to Subtract in Excel
    Type (CellName:CellName) in after SUM. This command adds all cells in a column from the first cell number value through the last cell number value.
    1. For example, if the K1 cell is your main number and the last cell in the column with data in it is K10, you'd type "(K1:K10)".
  10. Picture 27 of How to Subtract in Excel
    Press ↵ Enter or ⏎ Return. Doing so will run the formula in your selected cell, thereby replacing the formula with the final total.
Update 05 March 2020
celltypenumberclick

You should read it

Maybe you are interested

Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile