There’s no SUBTRACT function in Excel. However, there are many methods to subtract numbers in Excel. Are you willing to enhance your Excel knowledge? Then stay with us.
1. In this way, you can subtract values. You can see below we show the example. = A1-A2-A3
2. As you can guess, this formula can get long. Just use the SUM function to compress your formula. For example, the formula subtracts the values in the range A2:A6 from the value in cell A1.
3. Now in the next method, you can subtract a value from another cell value. Subtract B1 from the value in cell A1 See the example below.
Drag C1 corner down to the cell
4. Subtract the value in cell A8 from the value in cell A1. Set the reference to cell A8 by putting a symbol($) in front of the column letter and row number ($A$8).
The lower right corner of cell B1 and drag it down to cell B6.