Subtract Number in Excel | Advance Excel Course

There is no specific function for SUBTRACT value in Excel, The subtract operator in Excel is used to subtract one number from another. It takes two arguments: the first argument is the number from which you want to subtract, and the second argument is the number that you want to subtract from the first number. 

The formula for the subtract function in Excel is as follows

Syntax :

=number1 - number2

Example 1 :

=10 - 5

The result of this formula would be 5.

You can also use cell references in place of the numbers. For example, if you want to subtract the value in cell A2 from the value in cell A1, you would use the following formula:

=A1 - A2

This formula will subtract the value in cell A2 from the value in cell A1 and return the result.