Microsoft Office Tutorials and References

In Depth Information

**Converting the currency**

In other projects, you might copy formulae across different columns, and the

column references in the formulae will be updated as they are copied. To

stop that for a particular cell reference, put $ before the column letter (eg

$B2). You can ﬁ x both the row and the column at the same time (eg $B$2).

Adding in more expenses in pounds

There will be some expenses that need to be paid in pounds too, such as the cost

of ﬂ fights and airport parking. Where is the best place to put these on the

spreadsheet?

The golden rule is that everything in the same column should be of the same type.

If we enter our sterling costs in column B, we’ll end up with some of our values in

that column in euros and some of them in pounds. The number in a cell will have

a different meaning depending on where it is in the column. That can create a lot

of confusion later on. But we do now have a column at the end (column F) where

we can add additional expenses measured in pounds.

If you needed to work out these costs in more detail, using multiplication as we

did for the Euro costs, you could add another column for Price in pounds, and

reuse the units and quantity columns. I’m just going to add these as static costs in

column F.

Totalling the pound cost

Now, let’s see how much this jaunt is going to cost! We could create a long

formula to add up the total cost cells, using cell references of F5+F6+F7+F8 and so

on. But there is a function called SUM that makes it much easier. This is how you

use it:

1.
Put the cursor on the cell you would like the total to appear in. An ideal place

is at the bottom of the column you are totalling.

2.
Type the formula
=SUM(
.

3.
Click the cell at the start of the range you’d like to total.