Free computer Tutorials
Microsoft Excel 2007 to 2013
How to Subtract and Divide in Excel
In this part of the tutorials, you'll see how to Subtract and Divide in Excel. First up is subtraction.
Subtraction in Excel
You saw that to subtract one number from another, you just use the minus sign:
= A1 - A2
The image below shows the value in cell A2 being deducted from the
value in cell A1. The formula has been entered in cell A3.
If you want to subtract more than two cells you can do it like this:
= A1 - B1 - C1
In a later section, you'll see why that formula may not give you the answer you were expecting. But subtraction in Excel is fairly straightforward, and shouldn't cause you too many problems.
Division in Excel
Dividing one value from another involves using the forward slash symbol ( / ). An example of its use is this:
= A1 / C1
Here, we're just telling Excel to divide the cell value on the left of the slash symbol by the cell value on the right. Division is fairly straightforward, too.
You can combine all the basic arithmetic operators to produce more
complex formulas. We'll see how to do that now.