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 ﬁ 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