Excel Subtraction
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
The number that the subtrahend subtracts from is known as the minuend.
By entering a (–) in between the cells, you can add extra cells to the formula.
Let’s examine a few instances.
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 expand our working set of numbers. Enter the values listed below:
Subtracting using two cells, step by step:
- Type A3(=)
- Select A1
- Type (–)
- Select A2
- Hit enter
Subtracting Using Many Cells
Let’s use a lot of cells to remove. Enter the following values first:
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
A cell can be locked and taken away from other cells.
How to proceed, in detail:
- 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
The number that the subtrahend subtracts from is known as the minuend.
Let’s see an example in which the fill function and absolute reference are used to remove B(5) from the range A1:A10.
Enter 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 understand! You have successfully subtracted B1(5) from the minuend range A1:A10 using absolute reference.
