Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Analyzing foreign exchange rates
A question about something that is really frustrating me. I am trying to
adjust some raw data (for an international finance class) obtained from the Fed website regarding foreign exchange rates. One of the currencies I am using is the Japanese yen. My instructor has us converting this data to the direct rate, which is obtained (as I am sure you already know) by using 1/x. So the numbers I am working with (for the yen) is the INDIRECT rate. How, without going through each individual cell (he has us doing a full year) can I get the direct rate? I've checked the function formulas and they don't seem to have what I am looking for. Am I missing something here? I appreciate any help you can give me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for foreign characters | Excel Discussion (Misc queries) | |||
Using foreign characters | Excel Discussion (Misc queries) | |||
Foreign Exchange | Excel Discussion (Misc queries) | |||
Calculating Month Average Exch Rate from Exchange Rates Calendar!!! | Excel Worksheet Functions | |||
smart tag for exchange rates | Excel Discussion (Misc queries) |