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

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

Gary''s Student

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top