Microsoft Excel 2007

How to Subtract and Divide in Excel 2007

In this part of the tutorials, you'll see how to Subtract and Divide in Excel 2007. First up is subtraction.

Subtraction in Excel 2007

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 2007 is fairly straightforward, and shouldn't cause you too many problems.

Division in Excel 2007

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 2007 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.

< -- How to Multiply | Combine Arithmetic Operators in Excel 2007 -->

<--Back to the Excel 2007 Contents Page

View all our Home Study Computer Courses