98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Formula's
Formula's
Resolved · Low Priority · Version 2003
RE: 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:The dual nature of toolbar buttonsMany toolbar buttons are dual purpose, though the two purposes are often linked in some way. For example, Align Left aligns a cell's contents to the left of the cell. However, hold down Shift and press the Align Left button: Excel aligns the cell contents to the right. |