Microsoft Office Tutorials and References

In Depth Information

**Creating a Compound Formula**

Note

How Excel Copies Formulas
When Excel copies a formula, the ref-

erences change as the formula is copied. If the original formula were

=A10-A19 and you copied it to the next cell to the right, the formula

would read =B10-B19. Then, if you copied it to the next cell to the

right, it would be =C10-C19, and so on.

Creating a Compound Formula

If you need more than one operator for a calculation, you can use a compound formula.

Examples of a compound formula include =B7+B8+B12 or =B11-B19-A23.

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

swer.

Type the reference to the first cell of the formula.

Type the operator.

Type the reference to the second cell of the formula.

Type the next operator.

Type the reference to the third cell of the formula.