Microsoft Office Tutorials and References

In Depth Information

**Working with Formulas**

Working with Formulas

Many people use a worksheet

to perform mathematical calculations. By

using formulas, if a value in a referenced

cell changes, any formula based on the cell

automatically adjusts to accommodate the new value.

Excel can accommodate both simple formulas,

such as adding two values together, and complex

formulas, such as adding two values together and

multiplying the result by another number. In

addition, Excel can include the values from many

different worksheet cells.

address in color and places a matching color

box around the referenced address (see

Figure 9-1).

Tip

Worksheet cell references in formulas are

not case sensitive. For example, F2 is the

same as f2.

Creating Formulas

All formulas must begin with the equals (=) sign,

regardless of whether the formula consists of

adding, subtracting, multiplying, or dividing.

Formulas can reference either a static value or the

value in a referenced cell.

Creating a Simple Formula

An example of a simple formula is to add two cell

values together. For example, you could choose to

add the values of B5 and C5. Just follow these steps:

Figure 9-1

Referenced cells are bounded by a colored box.

1.

Click the cell in which you want to place the

result.

4.
A formula needs an operator to state the

next action to be performed. Operators are

plus (+), minus (-), multiply (*), or divide (/)

symbols. Type the operator.

2.
Type an equals (=) sign to begin the formula.

3.
Type the cell address of the first cell to be

included in the formula. This is called the

cell reference. Excel references the cell