Q:

# How do you subtract in Excel?

A:

To subtract in Excel, enter the numbers in a cell using the formula =x-y, complete the same formula using the column and row headings of two different cells, or use the SUM function with negative numbers. Excel does not have a specific SUBTRACT function.

## Keep Learning

1. Subtract two numbers

To subtract two numbers in a cell, type the formula =x-y, x and y are the desired numerical values. For example, if you type =11-4 and press enter, the cell displays the number 7.

2. Subtract two cells

You can subtract two cells using the same formula as above,by substituting x and y with the cells' column and row headers. For example, enter the formula =B5-B1 and if the number in B5 is 7 and the number in B1 is 3, the cell displays the number 4.

3. Subtract a range of numbers

Since Excel does not have a SUBTRACT function, you can use the SUM function to subtract a range of numbers by adding negative numbers. Convert any numbers that need to be subtracted to their negative values. If you need to subtract 200 from a range of numbers, change the value of the cell to -200. For example, subtract a range of numbers, by typing SUM(A1:A4) or SUM(A1,A2,A3,A4). If A1 is 100, A2 is -50, A3 is -25, A4 is 5, the cell displays 30.

Sources:

## Related Questions

• A: The average function on Excel allows you to find the average of a list of numbers, named ranges, arrays or cell references. This project takes just a few m... Full Answer >
Filed Under:
• A: The weighted average function in Excel calculates the average of a group of numbers with one or more of the numbers given more weight or a higher level of ... Full Answer >
Filed Under:
• A: To hide cells in Excel 2010, first identify the row or column you want to hide. With the row or column highlighted, select Format, Visibility and Hide Rows... Full Answer >
Filed Under:
• A: Using and Excel worksheet, a person can create a monthly budget by creating a layout with the months listed in individual cells along one row of the spread... Full Answer >
Filed Under:
PEOPLE SEARCH FOR