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