Coversion of Foreign Currency

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a xlw file with 9 sheets - each one holding a different type of
financial report. All of teh amounts are in a foreign currency. How can I
enter the foreign amounts in the workbook and then have Excel convert those
amounts into my local currency. Thank You
 
hi,
alot of way to go about this but basicly you will need a
minimum of 2 columns for that. 1 column to enter the
foreign currencies and 1 to hold a formula to conver the
foreign currencies into your local currency.
Assumming the foreign currency was in cell g2 and the
formula was in h2, the formula would look something like
this =(G2*exchange rate) then copy down
you could put the exchange rate in column h and the
formula in column i. =(G2*H2) then copy down
since exchange rates vary you might pick a place on the
sheet to put the current exchange rate. say A1 for example.
then the formula would look like this =(g2*$A$1) copy down.
Regards
Frank
 

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

Similar Threads

Toggling back and forth to track expenses in different currencies 2
Enforcing Links In Excel 1
Converting amount($) of my expenditure into the base currency i wa 1
fomula which returns the amount depending on the currency code 3
How to display negative $ amount?? 12
formula connected to a dropdown list 8
Multiply currency 5
Currency Formatting 2

Back
Top