Microsoft Office Tutorials and References
In Depth Information
Creating Formulas
Creating a Compound Formula
A compound formula contains more than one
mathematical operator. For example, suppose
that you want to calculate the amount of black
bean taquitos sold in August, but it’s a little
more complicated than simply knowing how
many taquitos you had at the beginning and end
of the month. You need to account for deliveries
during the month, and any returns for damaged
packaging/spoiled food. In order to calculate the
actual number of taquitos you had available for
sale, you take the opening inventory, add any
deliveries, and subtract the returns. From this
new balance, you subtract the closing inventory
(the number of taquitos left over at the end of
the month) to calculate the number of taquitos
sold. Your formula to calculate the total taquitos
available might look like this: =B12+C12–D12
(assuming B12 contains the number of taquitos
on-hand at the beginning of August, C12
contains the number of taquitos delivered during
the month, and D12 contains the number of
taquitos returned). Follow these steps to create
your own compound formula:
5. Click or type the address of the next cell you
want to reference in the formula, or type a
value. For example, click cell C11.
6. Type another operator such as + (addition),
– (subtraction), * (multiplication), or
/ (division) to indicate the next type of
calculation you want Excel to perform. For
example, type +. The formula now looks like
this: =B11+C11.
7.
Click or type the address of the next cell you
want to reference in the formula, or type a
value. For example, click cell D11.
8. Repeat Steps 6 and 7 as needed to complete
the formula. The formula now looks like this:
=B11+C11–D11.
9. Press Enter. The result of the calculation
appears in the cell you selected in Step 1,
as shown in Figure 2-5.
1. Click the cell in which you want the result of
the formula to appear. In this example, click
cell E11.
2. Type an equals (=) sign.
3. Click the cell you want to reference in the
formula, or type its address. You can type a
value (such as .25) instead of a cell address if
you like. For example, type =B11.
4. Type an operator such as + (addition),
– (subtraction), * (multiplication), or
/ (division) to indicate the type of calculation
you want Excel to perform. The formula now
looks like this: =B11+.
Figure 2-5
Compound formulas contain multiple
mathematical operators.

Search JabSto ::

Custom Search