Currency Conversion

Here's a way to set up a currency conversion spreadsheet.

Create a copy of the sheet from which you want the currency conversion.
In a convenient place in that sheet, put the conversion rate (and name it
"ConRate")
(Now the hard work) In the new sheet, go to each input cell and change it so it multiplies the cell in the original sheet by the conversion rate e.g. for the cell C4 you might insert the formula "=OriginalSheet!C4*ConRate".
Test your work by using a ConRate of 1
Now, whenever there's a change in the currency values you can update your
results.

Demo file: CurrencyConversion.zip

Published: 11-Aug-2005
Last edited: 11-Aug-2005 20:19