SUBTRACTION Operator (-) - Excel
Overview
The Subtraction operator (-) in Excel is a useful tool for performing mathematical calculations. This operator allows users to subtract values, cells, or ranges, which makes the creation of complex formulas possible.
Syntax:
=number1 - number2
Here, replace "number1" and "number2" with the specific cells, values, or ranges you want to subtract.
Example: specified cells
In this example, the Subtraction operator is referencing specified cells to do its calculation. Cell C2 equals 11 and cell D2 equals 10, when we subtract them using the Subtraction operator the output is 1.
Example:
=C2 - D2
Example: specified values
In this example, the Subtraction operator is referencing specified values within the cell to do its calculation. The values 5 and 2 are hardcoded into the cell and the final output is 3 when they are subtracted.
Example:
=5 - 2
Example: specified ranges
In this example, the Subtraction operator is referencing specified ranges to do its calculation. C2:C11 is the first range and D2:D11 is the second range. When we subtract the ranges using the Subtraction operator, the calculation automatically goes down each row and subtracts it.
Example:
=C2:C11 - D2:D11