Skip to content

How to Use Excel SUBTRACT Function?

Listen to this article
Subtract functionPin
Subtract function

The term “Subtract” is meant to find the difference between two numbers or values. Generally, Subtraction is one of the basic mathematical Operators. In Excel, we can use various built-in functions and formulas to perform mathematical operations. On that note, if you want to subtract any numbers or values in the Excel spreadsheet, we suggest you use the Subtract function.

It helps to do that even if you have large data. In this post, we will show you how to use the Subtract Function in Excel with the best examples. Get the official version of MS Excel from the following link:

Excel SUBTRACT FunctionPin
Excel SUBTRACT Function

Definition of Subtract Function

  • It is one of the built-in functions in Excel.
  • This function subtracts the values in the selected cells or ranges.
  • You can use this function to subtract the values of more than two cells in Excel.


  • Here, you will see the syntax of the SUBTRACT function.
  • To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
  • Once you enter the formula, just click on the Enter button to get the result.

=(1stValue – 2ndValue – …. – 255thvalue)

Argument Explanation

  • 1stValue– The first value you need to subtract. You need to use the cell number as a reference.
  • 2ndValue– The second value you need to subtract or use the cell reference.
  • 255thvalue– The last number that you need to subtract.
  • The number 255 is the maximum number of counts of cells.

Practical Examples

Here, we come up with some examples to make you understand how SUBTRACT function works on your Excel.

  • Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
  • In the following image, you can see the input values in cells B3 and C3. And we will get the subtracted value with the help of this function.
Input ValuesPin
Input Values
  • After that, we need to apply the above-mentioned formula in order to get the result in the spreadsheet.
Type the formulaPin
Type the formula
  • To execute the function, you need to click on the Enter button and get the subtracted value, as shown in the below image.
  • Let’s see one more example to make it clear for you. In the below-given screenshot, you will see a range of input values, and we will subtract those values using the following formula.


Execute formulaPin
Execute formula
  • Once you have executed the formula, you will get the result, as shown in the below image.


From this post, you can clearly understand the steps to use the Subtract Function in Office 365. If you have any queries or doubts, then kindly comment us below. To learn more about Excel functions, then visit our webpage

Video Tutorial

In this video, you will understand how to use the Subtract function in Excel.

Also Read:


Leave a Reply

Your email address will not be published. Required fields are marked *

Share to...