How Do You Subtract in Excel?
To subtract in Excel, enter the numbers in a cell using the formula =xy, 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.

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

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 =B5B1 and if the number in B5 is 7 and the number in B1 is 3, the cell displays the number 4.

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.