Microsoft Office Tutorials and References
In Depth Information
Calculating the total cost for each item
This isn’t the same as changing the format of a cell to display no decimal
places. The format only affects what’s displayed on screen and does not
change the underlying value of the cell or any calculations based on it. The
functions here change what’s actually stored in the cell.
Calculating the total cost for each item
In column E, you’re going to calculate the total cost in euros for each item on your
spreadsheet. That is calculated by multiplying the price for each item by the
quantity of that item. So to work out the total cost of Hotel Pierre, for example, we
multiply the cost per day by the number of days we will stay there.
So far, we’ve only used one cell reference in a formula, but you can incorporate
as many as you want, using any mixture of mathematical operators. Into cell E4,
enter this formula:
=B4 * D4
This means make the contents of cell E4 equal to the contents of cell B4 (the price
of a taxi) multiplied by the contents of cell D4 (the number of taxi trips). As you
enter each cell reference, Excel will highlight it on the spreadsheet, the fi rst one
in blue and the second one in green. In the formula bar, your cell references will
use the same colours, as you can see in Figure 5.4.
Figure 5.4
 
Search JabSto ::




Custom Search