Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
hOW CAN i EXTRACT THE EXCHANGE RATE BASED ON CURRENCY AND MONTH?
Here is the example: EXCHANGE RATES Currency JAN FEB MAR APR Belize 0.5076 0.5076 0.5076 0.5076 BP 1.7500 1.7700 1.7800 1.8000 Ca$ 0.7000 0.7000 0.7000 0.7000 CH 0.9000 0.9000 0.9000 0.9000 Euro 1.2700 1.3000 1.3200 1.4000 Honduras 0.0554 0.0555 0.0556 0.0557 Nicaragua 0.0667 0.0665 0.0667 0.0665 USD 1.0000 1.0000 1.0000 1.0000 __________________________________________________ __ Item Month Currency Lcl Currency Amount in USD Chocolate JAN Euro 100 Formula????? Flowers FEB Honduras 1500 Formula????? Petrol JAN Belize 250 Formula????? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
table | Excel Discussion (Misc queries) | |||
table | Excel Worksheet Functions | |||
Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions | |||
Formula to Extract Data from a Table | Excel Worksheet Functions |