Excel 2000

Introduction

By the end of this lesson, learners should be able to:

• Create a simple formula

Creating Formulas

In school, you may have had to memorize certain formulas in order to work math problems. Microsoft Excel uses formulas to perform calculations within a spreadsheet. In this lesson, you will learn how to use Excel’s formula features.

Creating a Simple Formula

Let's start with a simple formula that contains one mathematical operation. All formulas begin with the equal sign (=), whether the formula consists of adding, subtracting, multiplying, or dividing. Here's an example of a simple formula: =B2-B3.

To Create a Simple Formula using the Point and Click Method:

1. Enter the numbers you want to calculate.
2. Click the cell where you want the result to appear.
3. Type =.
4. Click on the first cell to be included in the formula.
5. Type a mathematical operator (Ex: the addition symbol +). The operator displays in the cell and Formula bar.
6. Click on the next cell in the formula.
7. Repeat steps 4 and 5 until the entire formula is entered.
8. Very Important: Press Enter or click the Enter button on the Formula bar. This step ends the formula.

If you simply move to another cell, Excel will include that cell in the formula.

Click the = sign button on the formula bar rather than the = sign on the keyboard to open the Formula Palette. The Formula Palette lets you see the progress of a formula as you enter it.

Excel will not always tell you if your formula contains an error, so it's up to you to check all of your formulas. To learn how to do this, read the Double-Check Your Formulas lesson from our Excel Formulas tutorial.

Challenge!

1. In cell A1, type 1,234.
2. In cell A2, type 15,865.
3. Click the cell where you want the result to appear.
4. Type =.
5. Click on A1.
6. Type the addition symbol (+). It displays in the cell and Formula bar.
7. Click on A2.
8. Very Important: Press Enter or click the Enter button on the Formula bar. This step ends the formula and your result appears.