Microsoft Office Tutorials and References
In Depth Information
Of course, if you do type something like
$39.75 into a formula, Excel will offer to
change it to 39.75 (the equivalent value)
if you want. If you don’t accept this kind
offer, Excel will mark the formula with an
error. In this case, you can edit the formula
and take out the dollar sign yourself.
However, if you’re interested in learning
more about how to deal with formula
errors, see Chapter 4, “Troubleshooting
Cell references in formulas are not case
sensitive; for example, C12 references
the same cell as c12 so you can type cell
addresses in upper- or lowercase as you
see ﬁt. However, after you complete the
formula, Excel changes the cell references
to uppercase automatically.
The color of the cell reference in the formula matches
the border surrounding the actual cell
Creating a Simple Formula
Simple formulas include only one mathematical
operator, such as subtraction ( – ). For example,
suppose you own a gourmet food service that
sells pre-packaged gourmet foods. Cell B12
contains the number of black bean taquitos you
had in stock at the beginning of August, and cell
C12 contains the number of black bean taquitos
left at the end of August. In order to calculate
how many taquitos you sold during August, you
subtract the value in cell C12 from B12. Follow
1. Click the cell in which you want the result of
the formula to appear.
Cells referenced in a formula are surrounded
by a colored box that matches the cell
address in the formula itself.
2. Type an equals (=) sign.
3. Click the cell you want to reference in the
formula, or type its address. For example,
click cell B12. Excel places a colored box
around cell B12; in the Formula bar, the cell
address B12 appears in this same color (see
Figure 2-3). You can type a value (such as .25)
instead of a cell address if you like.
4. Type an operator to indicate the type of
calculation you want Excel to perform. For
example, type + (addition), – (subtraction),
* (multiplication), or / (division).