Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Converting amount($) of my expenditure into the base currency i wa

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Converting amount($) of my expenditure into the base currency i wa

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

--
Gary''s Student - gsnu200831


"curious44" wrote:

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
fomula which returns the amount depending on the currency code Narnimar Excel Discussion (Misc queries) 3 November 23rd 08 01:50 PM
Base amount Nicola H. Excel Discussion (Misc queries) 5 August 9th 07 07:10 PM
how to convert the amount in currency into the amount in words? Ken Excel Discussion (Misc queries) 1 November 7th 06 10:16 AM
How to convert currency Amount in words in Excel ? Seebu Excel Discussion (Misc queries) 2 September 12th 06 11:18 PM
Converting amount in figures to amount in words Shrikant Excel Discussion (Misc queries) 1 August 16th 05 10:42 AM


All times are GMT +1. The time now is 03:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"