Now that
you have added your headings you can enter your
information.
The Total
Cost column will
be a calculation of the Years
of Training and
the Cost per
Year columns.
Once you have all the information added you will
format the cells to make this calculation. For now
leave the Total
Cost column blank.
After you have all
your information added you can complete the calculation
that will give you the Total
Cost. In the
first blank cell at the top of the Total
Cost column,
you can type the formula that will do the calculation.
You can
see that rows and columns are associated with letters
and numbers; these indicate its position in the
spreadsheet. For example, in the sample spreadsheet
the cells that contain the Years
of Training is
at position D4
and the Cost
per Year at E4.
You can use these positions to help create a formula
to do the calculation. The formula for the Total
Cost is "
=(D4*E4)",
this means the contents of D4
multiplied by the contents of E4
equals the Total
Cost.
Now let's create your formulas.
CREATING FORMULAS
Click
on the cell you want the formula to be created in.
In that cell, enterthe formula you want
to have calculated (example: =(D4*E4). The equals
sign indicates a formula.
Pressthe
"Enter" key to finish the formula. If
you want to change the input in cell D4 or D5, you
may do so and the formula will automatically update
itself.
