 Creating a Basic Spreadsheet Formula in WordPerfect Office 2002 - dummies

Creating a Basic Spreadsheet Formula in WordPerfect Office 2002

You can enter formulas in two ways in WordPerfect: Type the formula directly into the cell, or use a combination type-and-click approach. The following sections give you the lowdown on both methods, plus some other formula-writing tips.

Entering formulas for simple calculations

Before you enter a formula, remember one important rule of the road: In Quattro Pro, as in other spreadsheet programs, you don’t always use standard mathematical symbols, such as x for multiply and ÷ for division, when writing an equation. Instead, you use the symbols listed in Table 1, which are known as operators in spreadsheet country.

Table 1: Smooth Operators

 Operator Function + Addition – Subtraction / Division * Multiplication % Percentage ^ Exponentiation

With that bit of business out of the way, take these steps to enter formulas that solve simple calculations, such as 45 + 87.

1. Click the cell in which you want the answer to the calculation to appear.

2. Type a plus sign followed by your formula.

The plus sign tells Quattro Pro that you’re entering a formula. To calculate 45 + 87, for example, you enter

+45+87

If the first number in your formula is a negative number, you can enter a minus sign before the number instead of the plus sign. Formulas can also start with a parenthesis, or with the function symbol (@). If you’re used to starting formulas with an equal sign, as some other spreadsheet programs require, you can do so in Quattro Pro as well. Quattro Pro converts the equal sign when you complete the equation.

3. Press Enter.

If you have Formulas view turned on, the formula appears in the cell. Otherwise, the answer to the formula appears in the cell, and the formula itself appears in the input line. (Choose View –> Formulas to toggle between displaying formulas and answers in cells.)

Even if you turn off Formulas view, you can get a peek at the formula for a cell without activating the cell by pausing your cursor over the formula marker, which is that little blue triangle in the lower-left corner of the cell. Quattro Pro displays a QuickTip showing the formula.

Creating formulas using cell addresses

Although you can use Quattro Pro to perform simple calculations, more often than not, you’ll want to perform calculations on values that are stored in different cells in your spreadsheet. You can have Quattro Pro add the values in one row of cells, multiply that total by the value in another cell, and so on.

To enter this kind of formula, you use cell addresses instead of numbers to identify the values you want to calculate. A cell address contains the column name followed by the row name.

If you want to perform a calculation on cells contained on different worksheets in a notebook, include the sheet name before the cell address in the formula. To add the value of cell B6 on worksheet A to the value of cell B6 on sheet B, for example, you enter the following:

+A:B6+B:B6

If you named your worksheets, substitute that name in the cell address. If sheet A has the name July and sheet B has the name August,for example, write the following formula:

+July:B6+August:B6

Entering cell addresses with the mouse

If you’re creating a long formula and you’re weary of typing cell addresses — this computing business is such hard work! — use the mouse to enter the addresses instead. Here’s how:

1. Click the cell in which you want the answer to the formula to appear.

2. Type a plus sign.

3. Click the cell you want to reference in the formula.

For the formula +B4*52, for example, you click cell B4. The cell address appears in the input line and in the cell in which you’re entering the formula.

4. Type the next operator in the formula.

In the example formula, you type the * (multiplication operator). The cursor jumps back to the cell where you’re entering the formula.

5. Continue clicking cells and typing operators or values until the formula is complete.

In this example, all you need to do to complete the formula is to type 52.

6. Press Enter.