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

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).