Subtract cells (with references)
As you know, Excel allows you to input values in the cells of your worksheet.
So when you subtract in Excel, you can just click the cell that contains the numbers you want to get the difference between.
For example, if you want to subtract 5 from 10, you can click the cell references that contain these numbers.
You can find the cell reference in the name box found to the left of the formula bar.
Let’s try it👇
Let’s subtract 5 from 10 again but this time using cell references.
- Double-click an empty cell and type the equal sign (=) to start the subtraction formula.
In our example, it’s cell D3.
- Instead of typing 10, click the cell reference which has a cell value of 10.
In our example, it’s cell B3.
Then type the minus sign (-) arithmetic operator.
- Next, instead of typing 5, click the cell reference which has a cell value of 2.
In our example, it’s cell C3.
Now, Excel shows the following formula:
Excel displays 5 as the difference.
Using cell references in arithmetic operations like subtraction is a faster way to calculate numbers⚡
If you have data already stored in your worksheet, you won’t type numbers directly. Just click the cells with the values you want to subtract.
This way, it’s more accurate as you are less prone to typographical errors😊