Converting amount($) of my expenditure into the base currency i wa

  • Thread starter Thread starter curious44
  • Start date Start date
C

curious44

I am creating a personal expenses spreadsheet and have encountered a
problem.As I travel frequently, my spreadsheet lists the items and the amount
in a certain currency. In my case, its Thai Baht right now. However, Ive
included some items which are in other currencies(USD and Euro) and would
like the spreadsheet to output the final amount of each item in the base
currency I've chosen. In other words, If i choose to have my base currency in
USD(from an independent drop down cell), all the items in my list should
display the amount(my expenditure) in USD in another column, bearing in mind
I have more than 2 different currencies in my list. I have incldued in my
spreadheet the currency exchange rates for the various currencies i will be
working with. I just dont know where to go from here. Please advice. Thanks
for your time and patience.
 
First create a 2-D exchange rate table.
Each column would represent a sequential date and each row a currency.

You would then record your expenses in three columns:

A - the amount
B - the date
C - the currency
D - the calculated expense in the base currency

The values in column D would be the amounts in column A multiplied by the
results of the 2-D lookup.

For an example of a 2-dimensional lookup, see:

http://www.cpearson.com/excel/TablesAndLookups.aspx
 
Back
Top