Excel Subtraction Operator
Subtraction Operator
Subtraction uses the -
symbol, and is also known as minus.
How to subtract cells:
- Select a cell and type (
=
) - Select the minuend
- Type (
-
) - Select the subtrahend
- Hit enter
Note: The minuend is the number to which the subtrahend subtracts from.
You can add more cells to the formula by typing (-
) between the cells.
Let's have a look at some examples.
Subtracting Two Manual Entries
Let's start with adding in a formula. Start with a clean sheet
Step by step:
- Type
A1(=)
- Type
100-50
- Hit enter
Tip: You can add more values into the formula by typing (-) between the cells.
Subtracting Using Two Cells
Let's add some numbers to work with. Type the following values:
Subtracting using two cells, step by step:
- Type
A3(=)
- Select
A1
- Type (
-
) - Select
A2
- Hit enter
Subtracting Using Many Cells
Let's subtract using many cells. First, type the following values:
Step by step:
- Type
B1(=)
- Select
A1
- Type (
-
) - Select
A2
- Type (
-
) - Select
A3
- Type (
-
) - Select
A4
- Type (
-
) - Select
A5
- Hit enter
Subtracting Using Absolute Reference
You can lock a cell and subtract it from other cells.
How to do it, step by step:
- Select a cell and type (
=
) - Select the minuend
- Type (
-
) - Select the subtrahend and add two dollar signs (
$
) before the column and row - Hit enter
- Fill the range
Note: The minuend is the number to which the subtrahend subtracts from.
Let's have a look at an example where we subtract B(5)
from the range A1:A10
using absolute reference and fill function.
Type the values:
Step by step:
- Type
C1(=)
- Select
A1
- Type (
-
) - Select
B1
and type dollar sign before column and row$B$1
- Hit enter
- Fill
C1:C10
You got it! You have successfully used absolute reference to subtract B1(5)
from the minuend range A1:A10
.