Microsoft Office Tutorials and References
In Depth Information
Converting the currency
Converting the currency
All your prices are in euros, but that doesn’t tell you how much the holiday is
going to cost you in pounds sterling. Let’s add the exchange rate in a cell
underneath the trip length at the top.
Insert a row underneath the top row of your spreadsheet by clicking the heading
for row 2 to select it and then clicking the Insert button in the Cells section of the
Home ribbon. Excel will take care of the formulae; as everything moves down a
row, Excel will make sure the formulae are updated so that they are still
referencing the right data. Take a look at row 5, which used to be row 4. The total cost
formula has been changed so it multiplies cells B5 and D5, so all the data is still
correct.
There are different ways to express the exchange rate, but it’s easiest to enter the
number of euros you can buy with one pound. This is the fi gure you’ll be quoted
when you buy your currency. In reality, you’ll probably end up paying different
exchange rates depending on whether you use cash or credit cards, but the
standard rate is good enough for planning. You can get current exchange rates at
www.xe.com .
You can use the format painter (shown in Figure 5.1) to copy the euro
currency style from one of your existing currency cells onto your new cell. Click
on the cell you want to copy formatting from, click the format painter button
on the ribbon, then click the cell you want to apply the formatting to.
Let’s calculate our total costs in sterling for each row in column F. The formula we
need will be the total euro cost for that row divided by the number of euros a
pound can buy. Excel will format the column using the euro symbol
automatically, so you’ll need to change the currency formatting to the pound sign. Your
spreadsheet should now look like Figure 5.6.
 
Search JabSto ::




Custom Search