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
Search JabSto ::




Custom Search