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




Custom Search