3 Ways to Subtract in Excel

Table of contents:

3 Ways to Subtract in Excel
3 Ways to Subtract in Excel

Video: 3 Ways to Subtract in Excel

Video: 3 Ways to Subtract in Excel
Video: Three Ways to Indent Paragraphs in Microsoft Word 2024, November
Anonim

This wikiHow teaches you how to subtract one cell from another in Excel.

Step

Method 1 of 3: Subtracting Cell Values

Subtract in Excel Step 1
Subtract in Excel Step 1

Step 1. Open Excel

The app is green with a white cross "X" inside.

If you want to open an existing Excel document, double-click the Excel document

Subtract in Excel Step 2
Subtract in Excel Step 2

Step 2. Click Blank workbook (PC) or Excel Workbook (Mac)

It's in the upper-left side of the "Templates" window.

Subtract in Excel Step 3
Subtract in Excel Step 3

Step 3. Enter data if necessary

To do this, click a cell and then type a number, and press Enter or Return.

Subtract in Excel Step 4
Subtract in Excel Step 4

Step 4. Click an empty cell

This step will select the cell.

Subtract in Excel Step 5
Subtract in Excel Step 5

Step 5. Type "=" in the cell

Don't follow the quotes. The "equals" sign is always used before entering formulas in Excel.

Subtract in Excel Step 6
Subtract in Excel Step 6

Step 6. Type the cell name

The name entered is the name of the original cell that you want to subtract from the value of another cell.

For example, type "C1" to select a number in the cell C1.

Subtract in Excel Step 7
Subtract in Excel Step 7

Step 7. Type - after

A "-" sign will appear after the cell name.

Subtract in Excel Step 8
Subtract in Excel Step 8

Step 8. Type another cell name

This cell is the cell containing the value that will subtract the first cell.

This process can be repeated for up to several cells (for example, "C1-A1-B2")

Subtract in Excel Step 9
Subtract in Excel Step 9

Step 9. Press Enter or Returns.

This step will calculate the formula entered into the cell and replace it with the resulting number.

You can click a cell to display the original formula on the text bar just above the worksheet row

Method 2 of 3: Subtract in Cells

Subtract in Excel Step 10
Subtract in Excel Step 10

Step 1. Open Excel

The app is green with a white cross "X" inside.

Subtract in Excel Step 11
Subtract in Excel Step 11

Step 2. Click Blank workbook (PC) or Excel Workbook (Mac)

It's in the upper-left side of the "Templates" window.

Subtract in Excel Step 12
Subtract in Excel Step 12

Step 3. Click a cell

Unless you want to create data using this worksheet, select any cell.

Subtract in Excel Step 13
Subtract in Excel Step 13

Step 4. Type "=" in the cell

Don't follow the quotes. Now cells can be entered in formulas.

Subtract in Excel Step 14
Subtract in Excel Step 14

Step 5. Enter the number you want to subtract

A number will appear to the right of the "equals" sign.

To calculate a budget, for example, type your monthly income into this cell

Subtract in Excel Step 15
Subtract in Excel Step 15

Step 6. Type - in the cell

A "-" sign will appear after the number.

If you want to subtract several numbers at once (for example, X-Y-Z), enter each number after the "-" sign until the last digit

Subtract in Excel Step 16
Subtract in Excel Step 16

Step 7. Enter a number to subtract the first number

If you are calculating a budget, enter the amount of expenses in it

Subtract in Excel Step 17
Subtract in Excel Step 17

Step 8. Press Enter or Returns.

This step will calculate the formula entered into the cell and replace it with the resulting number.

You can click a cell to display the original formula on the text bar just above the worksheet row

Method 3 of 3: Subtracting a Column

Subtract in Excel Step 18
Subtract in Excel Step 18

Step 1. Open Excel

The app is green with a white cross "X" in it.

If you want to open an existing Excel document, double-click the Excel document

Subtract in Excel Step 19
Subtract in Excel Step 19

Step 2. Click Blank workbook (PC) or Excel Workbook (Mac)

It's in the upper-left side of the "Templates" window.

Subtract in Excel Step 20
Subtract in Excel Step 20

Step 3. Click an empty cell

This step will select the cell.

Subtract in Excel Step 21
Subtract in Excel Step 21

Step 4. Enter the main numbers

This number will be subtracted by the entire contents of the column.

For example, enter your annual income here

Subtract in Excel Step 22
Subtract in Excel Step 22

Step 5. Enter each subtractor in the cell below it

To do this, type the subtracting number preceded by a negative sign (for example, if you want to subtract 300, type "-300").

  • Type one subtraction for each cell.
  • Make sure each number entered is in the same column as the main number.
  • For the salary example, for example, type "-" followed by the amount of expenses in each cell.
Subtract in Excel Step 23
Subtract in Excel Step 23

Step 6. Click an empty cell

This time, the cells don't have to be in the same column as the leading numbers.

Subtract in Excel Step 24
Subtract in Excel Step 24

Step 7. Type "=" in the cell

Don't follow the quotes. Now cells can be entered in formulas.

Subtract in Excel Step 25
Subtract in Excel Step 25

Step 8. Type SUM in the cell

The "SUM" command will sum all cells.

This command is not really a "subtraction" command, which is why you must enter numbers in the negative form

Subtract in Excel Step 26
Subtract in Excel Step 26

Step 9. Type (CellName:CellName) after the SUM

This command will add up all the cells in the column from the first cell to the last cell.

For example, if K1 is the main number and the last cell in the column is K10, type "(K1:K10)".

Subtract in Excel Step 27
Subtract in Excel Step 27

Step 10. Press Enter or Returns.

This step will calculate the formula entered into the cell and replace it with the total.

Tips

You can also use Excel to add up numbers

Warning

Forgot to type = in the cell before entering the formula will fail the calculation.

Recommended: