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.

 

Combine Arithmetic Operators in Excel 2007 to 2013 -->

<--Back to the Excel Contents Page

View all our Home Study Computer Courses