Microsoft Office Tutorials and References
In Depth Information
Chapter 9: Playing with Formulas
2. Type the equal sign (=).
This tells Excel that you are creating a formula.
3. Type your formula that includes one or more cell references that
identify cells that contain data, such as A4 or E8.
For example, if you want to add the numbers stored in cells A4 and E8,
you would type =A4+E8 .
4. Press Enter.
Typing cell references can get cumbersome because you have to match the
row and column headings of a cell correctly. As a faster alternative, you can
use the mouse to click any cell that contains data; then Excel types that cell
reference into your formula automatically.
To use the mouse to click cell references when creating a formula, follow
these steps:
1. Click in the cell where you want to store the formula. (You can also
select the cell by pressing the arrow keys.)
Excel highlights your selected cell.
2. Type the equal sign (=).
This tells Excel that anything you type after the equal sign is part of your
formula.
3. Type any mathematical operators and click any cells that contain
data, such as A4 or E8.
If you want to create the formula =A4+E8, you would do the following:
a. Type .
This tells Excel that you’re creating a formula.
b. Click cell A4.
Excel types the A4 cell reference in your formula automatically.
c. Type .
d. Click cell E8.
Excel types in the E8 cell reference in your formula automatically.
4. Press Enter.
After you finish creating a formula, you can type data into the cell references
used in your formula to calculate a new result.
 
Search JabSto ::




Custom Search