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.