Microsoft Office Tutorials and References

In Depth Information

**Cell Formula Basics**

Cell Formula Basics

Creating a Simple Formula

You can use a simple formula to add, subtract, multiply, or divide two numbers. An ex-

ample of a simple formula is =A1+A2, which adds the contents of cells A1 and A2.

Type an equal sign (
=
) in the cell where you want to place the formula an-

swer.

Type the cell address (such as
A1
) of the first cell to include in the formula.

This is called the cell reference.

Type an operator to indicate the action to perform: plus (
+
), minus (–), mul-

tiply (
*
), or divide (
/
).