Formula's

Hi Joseph,

Welcome to the forum, thank you for your post;

In answer to your question:

To Enter Formulas by typing the cell references:
First select the cell where you want the result to appear. Then you type the formula in the selected cell. eg, if there are numbers in cells A2 and A3, and you want to add them and show the result in cell A4, you would:
1. Select the cell where you want the formula to appear (ex: A4).
2. Enter the formula (ex: Type =A2+A3 in the cell A4).
3. Press Enter.
4. The result will appear in A4. If A4 is the active cell the formula will appear in the formula bar.

To use the mouse to enter cell references:
You can use the mouse to enter cell references while you are creating formulas.
1. Select the cell in which you want to enter the formula.
2. Type = (to begin a formula)
3. Click the cell for which you want to enter a reference.
4. Type the operator you want.
5. Repeat steps 3 and 4 until you've created the formula you want.
6. Press Enter.

To use the mouse to enter range references:
You can use the mouse to enter a range reference in a formula or function
1. Enter the equal sign, function name, and opening parenthesis (Brackets) for the function
2. Drag over the range for which you want to enter a reference
3. Type the closing parenthesis.
o You can enter more arguments by typing a comma (,) and continuing.
4. Press Enter.

To Edit Formulas:
You can edit formulas as you would edit any other data. Select the cell, click the formula bar, edit the formula, and then enter the edited formula.
Using the Edit Formula button:
1. Select the cell containing the formula you want to edit.
2. Click the Edit Formula button on the Formula Bar.
3. Edit the formula.
4. Press Enter or click OK.

Don