Microsoft Office Tutorials and References
In Depth Information
Creating Formulas
Tip
Cell References
Aren't Case-Sensitive
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
Formula Errors.”
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
these steps:
1. Click the cell in which you want the result of
the formula to appear.
Figure 2-3
Cells referenced in a formula are surrounded
by a colored box that matches the cell
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)